HF scientific Online SCADA System - Manual (Page 25)

(8/02)
Rev 1.2
23
4.0 Report Generation
4.1 Overview
The SCADA system allows the user to generate query-based reports from the
historical data that is collected by the Citadel database. The system can also be set
up to log data in .csv (comma separated values) format files which can be opened
directly in any spreadsheet programs such as Excel. The .csv files can also be
converted into Access database files. The report generation is done using the
report generation process, which can be accessed from the Summary panel using
the Report push button.
4.2 Report Configuration Panel
This panel (refer to Fig. 4-1) allows the user to configure the query-based reports
that are generated from data logged to the Citadel historical database. This panel
also provides the user with the option to log turbidity data in .csv format at a user
specified interval, path and file name. The Report Configuration panel has the
following features:
Tags: This is an array of text entry boxes with which the user can specify:
Column Subtitles: These are the column subtitles as they should appear on the
report. The subtitle should not be more than 8 characters long. It should be noted
that the SQL query based report is configured as a 32 column and a 31 row report.
The basis for the 32 columns is the 32 devices that the Online SCADA system can
handle. Hence the column subtitles would be essentially the device names (Filter
1, Filter 2 etc.).
Object Names: The Object Name specifies the name of the tag in the Citadel
database that the user would like to create the report for. The reports are set up for
the turbidity values and the Object Name is Server\DeviceTable\DeviceXNTU
where X denotes the device address. For example, the Object Name for the
turbidity value for Device 1 would be Server\DeviceTables\Device1NTU. The
Online SCADA system is configured to log only the turbidity value to the
database. The object names are already entered in the table and should not require
any editing by the user.
Note: Editing these object names may result in improper operation of the report
generation function.