Data Report Generator

By Custom Computer Systems  

www.davidhagemann.com

The Data Report Generator is a custom application for generating Metasys feature data reports.  You can report Trend, Totalization and Point History information for a specified date range with the click of a button.  You have two types of reports you can generate - Details Report or Summary Report.  The Summary Report only show the summary for all selected objects. The summary consists of the Value, Date and Time of the High and Low samples for the selected date range.  The Average value is listed and if the feature is Totalization, the Total for the date range is included also.  The Detail Report shows the same summary but also includes a list of all samples, and automatically generates a graph. 

Home  -  Report Tab  -  Data Details Tab  -  Setup Tab

Report Tab

1. Select the Objects you want the report for. The Select All button will select all of the objects in the list.  The Clear All button will de-select all of the objects.

2. Select the Start Date and End Date by clicking on the calanders. Note - You must click on the day to change the start date and end date. Just changing the month does not change the start date or end date.

3. You have two types of reports you can generate - Detail Report or Summary Report.  The Summary Report only show the summary for all selected objects. The summary consists of the Value, Date and Time of the High and Low samples for the selected date range.  The Average value is listed and if the feature is Totalization, the Total for the date range is included also.  The Detail Report shows the same summary but also includes a list of all samples, and automatically generates a graph. 

4. Click the Generate Report button.

If a Detail Report is selected, the report output is an Excel Workbook that contains two sheets for every object that was selected.  One sheet for the summary and the samples, the other sheet for the graph as shown below.  The file name is the end date in the format of yy-mm-dd.xls and is automatically stored in the Reports directory under the location the application was installed in.

If a Summary report is selected, the Excel workbook has one sheet with a summary of all selected objects as shown below.

Home  -  Report Tab  -  Data Details Tab  -  Setup Tab

Data Details Tab

Clicking on any Object name will collect the data for the date range specified in the Report Tab.  You can display the Details or just the Summary by selecting the desired option.You can send this data to either Notepad or Excel by clicking the To Notepad or To Excel buttons.  

Home  -  Report Tab  -  Data Details Tab  -  Setup Tab

Setup Tab

On the Setup Tab you can Add or Delete Objects from the list.  You can also change the type of graph that is generated with the Detail Report.

To Add an Object to the list -

1. Click the Setup tab.

2. Click the Add Object button.

3. Select the type of Feature you are adding (Totalization, Trend or Point History).

4. Select the PCFile Name.

5. Double-Click the System\Object names you want to add. You can narrow the list by selecting a particular object type.  When you are finished adding objects click the Done button. Note - You can add different features of different objects from different PCFiles.

Home  -  Report Tab  -  Data Details Tab  -  Setup Tab

****************************************************