JCI Custom Reporting Tool

Overview of JCI Reporting Tool

The JCI Custom Reporting Tools was built to satisfy JCI customer's requests for an easy to use Administrative Reporting tool. The system allows the arranging of sensors (gizmos) into logical groups so that a user with little knowledge of the MetaSys Software can view managerial reports. These reports are viewable using any standard web browser and can be printed and viewed as a PDF.

Reports are created by the end user and all reports are available to all users. Each report can be printed by date range so that any timeframe can be viewed quickly. Reports can also be scheduled to be autogenerated and emailed to employees so the data is waiting in their inbox when the arrive at the office.

Setup

Setup Buildings, Floors and Rooms

All information is arranged by rooms. All gizmos have a physical location so they must be attached to a room. Rooms are arranged just like in the real world. Rooms are on floors in a building so you must first describe the building properties before any reports can be created.

Once you have created the buildings, floors and rooms for each floor you will be ready to query your database for NAE devices.

Rooms and Gizmos

Setting Gizmo Locations

Once the Rooms are created in the database and the Objects are imported from the NAEs the Objects can be attached to their Physical locations. Double click any row in the grid and the form above is displayed. Select the Room where the device or gizmo is located and that's it. You can also change the Column Name to something more descriptive so that you can find it easly in the configuration screens in the next steps.

Adding Rooms to Report

Linking Gizmos to Columns

Once the rooms for the report are defined and the columns are completed then you must link the gizmo to the column. The field definition determines how the data is collected (max, min, avg, etc) for each column on a gizmo by gizmo basis. Once each room (row) has it's respective columns defined you are ready to generate the report.

Importing Gizmos

Importing NAE Information

Click the Refresh Object List button will cause the Reporting Tool to connect to the MetaSys Database and download a list of all NAEs. Each NAE object list is then traversed and all Field Devices and Field Points are enumerated and imported into the Reporting database. Remember that just because the objects are added to the list does not mean they will appear in your reports.

Creating Reports

Connecting Report Columns to Rooms

Defining the columns for a report is done using the screen above. You can define how the data is collected by selected one of the following options which are retrieved from the Historical database for the date range specified in the report:

Current Value: this is the current value of the reading in the NAE...not history.
Show Max Value: the history database is queried to retrieve the max value
Show Min Value: the history database is queried to retrieve the min value
Show Avg Value: : the history database is queried to retrieve the avg value
Event Count: count the number of alarm events
Sum Total: sum all the values
Room Information: details about the room
Low Alarm Value: the low value which generates an alarm defined in the NAE
High Alarm Value: the high value which generates an alarm defined in the NAE

Once the columns are defined you must tell the report generator which rooms should be used in the report in the next section.

The reports are stored on the server and can be accessed using the web interface. All runtimes and libraries are on the server and are not required on the client computer to generate any of the reports. All that is required is Adobe Acrobat Reader.

Web Report Generator

Pick your report along with the start and end date to generate your report. When the Run Report button is clicked the grid is loaded with the query data. Once the report is completed click the "Print Report" button to export the data to a PDF file for downloading, printing or emailing.