3 Statistic > 3.6 Report Template Builder – Statistic Data
3.6 Report Template Builder – Statistic Data
ReportView.bmp The Report Template Builder for statistic data is designed to provide great flexibility when generating reports (in Microsoft Office Excel XLS format) from statistic data. The basic operation is the same as described for the Report Template Builder used for measurement data.
The Report Template Builder for statistical data is accessed by selecting Report Template Builder from the Statistic menu on the Main Window.
 
Currently, TEMS Discovery provides four types of statistic reporting: Chart, Map View, Single value (the result is a single value), and Tabular.
A right-click at the spreadsheet will bring up the context menu described below.
Remove Chart. Remove the chart definition and clean up the chart area.
Remove Map View. Remove the Map View definition and clean up the view area.
Repetition in Report. Define repetition options in the report template. See Options of Repetition in Report.
Repetition Flag. Define a repetition flag in the cell as a placeholder. This placeholder will be replaced with the value of the repetition key when the report is generated.
Chart Skeleton. Define a Chart Skeleton.
 
 
Single Value. Generate a single value
 
 
Chart: Generate a chart
 
 
Map View: Generate a map view
 
Tabular: Generate a tabular
 
 
Certain filters can be applied to any of the report types.
C:\Users\USDIJA\Documents\backup\TEMS Discovery\TD DocToHelp Projects\MASTER IPP Collection with PNGs\Statistic Report Definition - Dimension Filter.png
 
Dimension Filter: When you generate a report based on a report template, you may want to apply certain filters to all reports. (See Generate Statistic Report From Report Template for more information.)
The following dialog provides a way to list those filters in the final report.
C:\Users\USDIJA\Documents\backup\TEMS Discovery\TD DocToHelp Projects\MASTER IPP Collection with PNGs\Statistic Report Definition - Overall Dimension Filter.png
 
3.6.1 Generate Statistic Report From Report Template
The Statistic Report Generation dialog is accessed by selecting Report Generation from the Statistic menu on the Main Window.
 
The process is similar to that described for generating a report from the Report Template Builder for Measurement Data. Time and dimension filters can be applied.
You can simply change the data scope to apply the same report template to different data source.