Report Output and Formatting

A Table Query Report will automatically generate a CSV format report. It is important that NO file extension is included when defining the filename parametre since the ".csv" file is automatically created.

The CSV sub-report contains comma separated text values which can be read into a text editor or spreadsheet application. This sub-report contains the simplest formatting, with the first row containing the column headings and subsequent rows containing values for each period. The first column in the table contains the period number, with a column heading of 'PERIOD'. Subsequent columns contain the unique target names sorted in alphabetical order, and the final column contains row totals with a column heading of 'TOTAL'. The following shows a sample of a CSV format file: