Report Output and Formatting

A Period Category Report will automatically generate three formats: HTML, PNG and CSV. Each of these reports contains the same data and ranges, however it is formatted appropriately for the output style. NO file extension should be included when defining the filename because ".html", ".png" and ".csv" are automatically created for each Period Category Report.

The CSV sub-report contains comma separated text values which can easily be read into any text editor or spreadsheet application. This is the report with the simplest formatting, where the first row contains column headings and each subsequent row contains data values. The number of rows is equal to the number of specified periods, and each row ends with a TOTAL of all ranges in that period. The following example was taken from the range labels defined above.

	PERIOD,Regen,1 - 20,21 - 40,41 - 60,61 - 80,81 - 100,101 - 120,121 - 140,140+,TOTAL
	0,562,11291,10678,1357,20235,37621,15600,14596,15108,127047
	1,0,9869,9648,4371,20235,37621,15600,14596,15108,127047
	2,0,6811,10120,6816,11816,25072,30895,15278,20241,127047
	3,0,3264,12034,8338,7630,29368,30895,15278,20241,127047
	4,0,562,11291,10678,1357,20235,37621,15600,29704,127047
	...

      

The HTML table holds identical information, however, it is presented in a well formatted table with clear headings and columns. The Column headings are derived from the Range Labels or categories defined in the PIN file. The first column of this type of report is always the 'PERIOD" number and the last column is always a 'TOTAL' for the entire row (period totals).

Figure 105. Period Category Table in HTML format

The figure shows an example of the table portion of the HTML report. The colour-coded areas show columns common to all Period Categorey Reports (Blue), category column headings (Green), and cell values (Tan).


The default report created by the Report Writer is the HTML version. This particular report contains the above table as well as, a title with scenario name, an embedded PNG version of the report, optional HTML text or data (additionalHTML), a link to the CSV sub-report and a link to an index report.

The PNG sub-report shows a stacked-bar chart with one bar for each period, and one stack for each designated category. The Y-axis is automatically scaled to fit the data, and labeled with the units parameter. The X-axis displays period numbers (for example T0, T1, T2...). A legend is created to the right of the chart to indicate the value of the illustrated categories.

Figure 106. PNG Sub-Report produced by Period Category Report

The stacked bar chart is automatically created and embedded in the HTML document. See the General Report Format for the layout of common reports.