Previous page

Next page

Report Format Options

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:

  • A report text file (.tra) that they could open only in the PayGlobal report viewer by entering the specified password.
  • A zip file containing the report .txt file that they could extract only by entering the specified password.

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.

In This Section

Set up Designer Report to Use Specific Format