Adding Fields and Exporting the File
<< Click to Display Table of Contents >> Navigation: Using The System > Advanced Features > Custom Reports > Creating a Data Export File > Adding Fields and Exporting the File |
Selecting Fields for the Data Export
In the 'Fields to Export' box, click in the first available line, then click on the drop down arrow to reveal a list of choices. Click on a field name, and the field will be added.
Continue adding fields in this manner until you have all of the fields required. In the example below, fields for Make, Model, Base Cost, New/Used, and Year have been selected.
If you want to include the field header names in the export file, check the Include Field Names checkbox above the listing of fields.
A full list of fields and descriptions available for export can be found at the following links:
Note: Remember, the data fields in this file are separated by a tab character! This is convenient if you want to open the file in Microsoft® Excel or an other spreadsheet program which recognizes delimiters.
In the lower right corner are other options for sorting and formatting the data. Click here to find out how to use the Runtime Filter to apply a filter.
You can specify a default path and file name in the Default Export File Location box.
This location must contain the fully-qualified path name and file name for the file.
If you do not specify a location, the system will display a window where you can navigate to a location and specify a file name. You can also click the Browse button to select a default location for your file.
Click the Save button to name and save your export file layout. The export file can then be created just as if you were printing a paper report.
When you have completed the set-up of your data export file, click the Export Now button to immediately create the file with the specified data.