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:
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.) |
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. |