Reports | Report Groups | Reports tab | Edit Destination/Format
The following table explains the Format options available on the Report Destination form.
Format |
Details |
|
ArchiveFile |
This default option is the PayGlobal Internet format. The person who receives the report can view ArchiveFile reports in the PayGlobal Report Viewer. |
|
PDFFile |
Adobe Portable Document Format file (.pdf) |
|
LotusFile |
Lotus Notes file |
|
QuatroFile |
Quatro file |
|
ExcelFile |
Microsoft Excel file (.xls) |
|
RTFFile |
Rich text Format file (.rtf) |
|
ReportTextFile |
Plain text file (.txt) If you wanted to securely email a report, then you could use Format = "ReportTextFile", click Use compression, and specify a password and address. The addressee would receive:
|
|
CSVFile |
Comma-Separated values - Data file with values separated by commas (.csv). If you use this option in a designer report, then the resultant CSV file will contain additional quotation marks around strings that include spaces. Recommended for designer reports only. Although you can use CSVFile for hard-coded reports, header and data formatting can be inconsistent or not work at all. |
|
CSV2File |
Available in designer reports only. If you use this option in a designer report, then the resultant CSV file will not contain additional quotation marks around strings that include spaces. |
|
Note: Strings or numeric values that include commas are enclosed in quotes for Format = "CSVFile" and "CSV2File". |
||
TabDelimitedFile |
Data file with values separated by tabs. Recommended for designer reports only. Although you can use TabDelimitedFile for hard-coded reports, header and data formatting can be inconsistent or not work at all. |
|
FixedWidthFile |
Columnar data - Each field has a specified length and position that is the same in every record. Recommended for designer reports only. Although you can use FixedWidthFile for hard-coded reports, results are inconsistent and often this format does not work at all. |
Reports contain a default set of Format options, but not every report is rendered correctly in all of these formats, particularly "ExcelFile". We recommend that you use format specified for the report in the Standard Report Catalogue manual or Help file.
Use the following Format options for designer reports only:
You cannot use these options for hard-coded reports because the data type and amount can cause complications.