To export data to a file, select Export to File in the Export Report Layout window, and enter the information in Table 23.
Table 23. Export Information
| Delimiter | Description |
|---|
Numeric Column Delimiter | Delimiter to use for numerical data. Click the arrow next to the field to select an option. |
Text Column Delimiter | Delimiter to use for text. Click the arrow next to the field to select an option. |
Separator | Character used to separate the data. Click the arrow next to the field to select an option. |
Fixed Length Columns | Indicates whether the columns will be a fixed length. |
One Column Per Line | Indicates whether there will be one column per line. |
Note:
SQR Production Reporting Studio does not analyze the output from the database to determine if a delimiter is also used as a character of data, so you should choose your delimiters carefully.
Note:
You can set default information that will appear in the Export to File section of the Export Report Layout window by selecting File/Edit, then Preferences and clicking on the Export tab.