Report options

Menu location: Reports menu, Report Setup, Report Options

Using CSV reports

Through Report Options, you can set defaults for the date format in certain report headings, the CSV report delimiter, and the CSV report text qualifier for all applicable reports generated at your site.

Date formats

The Date Formats item applies only to the heading date in either PDF or TXT report formats. The default format is short (07/31/2018). Click the long format (July 31, 2018), if you want to change it. This setting cannot be overwritten by any other feature.

CSV options

Many reports are available in the CSV (delimited) file format. Use these files to populate data in external programs. To make this export easier, use the CSV Options page to change the data delimiter and the characters that surround data that should be interpreted as a text string (text qualifier). You can override these CSV settings, if the report is generated automatically through an auto module.

The native file name extension for most CSV reports is .CSV. A handful of specialized CSV reports use a different file extension. If the external system to which you upload the data requires a different extension, manually change the file name before uploading the data.