Tabular reports display information in a tabular (row and column) format. Each module has its own set of Tabular reports.
The configuration dialog box for Tabular reports is launched by right-clicking a Tabular-type report and selecting Setup/Show Report. This dialog box contains the following:
- As of Date check box: For those applications that have tables set to be temporal, the top of the window provides the As Of Date check box and a calendar field. The window also provides a drop-down list to designate whether the selected as-of date is the system date or the effective date (which is only utilized if the application includes Network Manager). Once you select this check box and enter a system or effective date, then only data with a time-stamp equal to or after the entered date will be used in generating tabular reports.
- Filter: This opens the Filter dialog, which allows you to restrict the data used in the report.
Data Aggregation check box: When this check box is selected, all records in the database are summarized into a single record for each non-numeric column that you select to be included in the report. The numeric values in each record that are summarized are aggregated as specified in the Data Aggr. Func. column in the List of Columns pane. (When you select the check box, the aggregation method is automatically set to Total for each column containing numeric data. This helps you to see which columns contain numeric data.)
For example, say you are creating a report showing total costs for 10 administrative units. The database contains 5000 Day Cards. If you do not select the Data Aggregation check box, the report will show 5000 rows — one row for each Day Card. However, if you do select the check box, then the report will show only 10 rows — one row for each administrative unit (with the total costs being the sum of all Day Cards for that administrative unit). If you elected to include subunits in the report (and each administrative unit contained two subunits), then the report would contain 20 rows — one row for each administrative unit/subunit combination.Note: If you change the aggregation type from Total to some other type and then clear and re-select the Data Aggregation check box, your selection will be lost. (It will be restored to the default type, which is Total.)
- List of Columns pane: This pane lists all columns available in the view that underlies the report. The columns that are actually used in the report are indicated by a check mark in the Show column. The order of the listed columns from top to bottom corresponds to the order of the columns in the report from left to right. See List of Columns Pane for more information.
- Order By pane: This pane lists the columns that are used to sort the information in the report and whether the sort is in ascending or descending order. It also indicates if subtotals are to be included in the report. The columns that appear in this pane are those with a check mark in the Order By column in the List of Columns pane. See List of Columns Pane for more information.
Show Report: This button displays the report in a new browser window. The report is displayed in one continuous table that is divided into virtual pages. The size of each virtual page varies between 100 and 900 rows. The default value is 100. To change this value, select the desired number of rows from the drop-down list shown at the top right of the report. (The setting of the drop-down field has no effect on printed output.)
Note: Tabular reports may be downloaded in a variety of formats by selecting the desired format and then clicking Download on the browser page showing the report.For XLS and XLSX formats, the size of the report is limited by the value in SYSTEM_ADM.GRID_REPORT_IN_MEM_SIZE_THRS. If the size of a report (columns times rows) exceeds this value, the system generates the message, "The entire report cannot be downloaded in this format. The limit is [value] (rows * columns)." To recover, you must either export fewer records or change the limit.
Also, for CSV files, all fields are enclosed in double quotes to handle the presence of any commas in the output data.
