You can make some customizations to the appearance that the exported files will take. With the Settings page open, click the Export Settings tab to see the available options:
Page Options affect the size which PDF, RTF, and Excel exports will show on a screen and on print.
General Options allow you to restrict available export types, and choose a default type.
Include Setup Info: Choose whether to include some information about the fields, sorts, and filters in the body of the file.
Use Group Color Styling: Choose whether to include the group header colorings in the output file.
'No Data Qualified' Mode: If the ExpressView returns no data, choose whether to render an empty file, or show a user message instead.
Flatten Groups in Excel and CSV: For Excel or CSV files, choose whether to automatically ungroup, or "flatten" all group columns into data columns. This may make the output more suitable for data analysis.
Keep Cell Styling in Excel: For Excel files, choose whether to show styling, such as font and row shading, or to show only the bare data.
Exporting ExpressViews to Other Types
ExpressViews can be used as a starting point to quickly add fields to a report, before delving into some of the more advanced reporting capabilities. The ExpressView format is not compatible with the report designer, but you can export it to an Advanced Report and edit the copy.
To export an ExpressView to an Advanced Report:
- Click the Settings icon.
- Click the Create Advanced Report tab.
- Enter a name for the report and select a folder where it should live.
- Click Create Advanced Report.
Note: Beginning in v2018.2, Advanced Reports converted from ExpressViews will retain reprinting of group headers by default if detail section spills to the next page.
If you to save an ExpressView as a file, it be exported as PDF, RTF, CSV, or Excel. Each format has some advantages and disadvantages.
- PDF is closest to the look of the ExpressView, and is suitable for printing and emailing. But if there is a large amount of data, you may have too many pages, or too large a file size.
- RTF retains the basic look of the ExpressView, and can be opened in a word processor for any additional editing. But it may look different depending on the program it is viewed with, and it is not suitable for viewing large amounts of data.
- CSV retains only the data, and none of the look of the ExpressView. It is best used if you need to process a large amount of data in an accounting or analysis program.
- Excel retains the data, visualization, and optionally, some styling. It is a good hybrid format if you have a lot of data, but you still need it in a visually presentable form.