HyperTACII provides you with a variety of reports that allow you to monitor the activity and performance of your telemetry equipment. The reports gather and filter information, based on parameters you provide in the Report Request Form, and present the data in a meaningful and useful form.
The following reports are available:
The data stored in HyperTACII's journals and logs is maintained in the active system for a limited period of time. After this time, it is moved to an archive in order to optimize hard drive space and system communication time. To retrieve historical data, ...
| Data Type | Archived After |
| Access log | 1 year |
| Comment log | 1 year |
| Journals* | 1 year |
| Alarm log | 6 months |
| Control log | 3 months |
| Radio error log | 14 days |
*A Journal is created for each 24 hour period beginning at midnight. Journals contain all system data except for that stored in HyperTACII's Logs.
The first step in generating a report is completing the Report Request Form. The Report Request Form is basically the same for each report type. Some reports, like the Analog (Flow) Report and the Radio Error Report, have additional parameters that must be set. The difference lies in what happens behind the scenes – what information the system requests from the database and the methods used to generate and present the report.
The sections below, Saved Parameters, Report Selection, Report Options, and Special Features, describe in detail each of the Report Request Form's fields.
The Derived Flow Report Request Form is show below.
There are certain reports that you want to run on a regular basis (daily, weekly, monthly, etc.). With HyperTACII's report generator, you can set the report parameters (type of report, telemetry address(Es) for which you are creating the report, report period, etc.) and Save it. The next time you want to run the report, you simply Load its parameters and run it. Optionally, you can Delete a report that has become obsolete.
For specific instructions on saving, loading, and deleting report parameters, see Saving, Loading, and Deleting Reports.
In this section of the Report Request Form, you select which type of report you want to generate. Your options are:
For detailed information on these reports, select a report title from the menu at left.
Report options vary according to report type. Each of the report options are described below. The report to which the option applies appears in parenthesis after the option's name.
To access these options, click Report Options on the Report Request Form.
For Report Source, you can enter station numbers, station names or telemetry addresses, and/or select a keyword that you've configured. You can manually type in the telemetry addresses, or use the Browse button to navigate to the address and select it.
If the stations have been named using a specific format (discussed in HyperTAC II's online help), you can enter station names in the Report Source box. Results will be returned sorted in ascending order according to the entries in the station name field.
To gather information on multiple stations or telemetry addresses, enter the desired station numbers or telemetry addresses separated by commas. For example, to retrieve information on stations 1, 5, and 7, enter 1,5,7 in the Report Source box. You can only select one address at a time using Browse, but you can create a comma-separated list of addresses by using Browse multiple times to select the desired addresses.
To retrieve information on all telemetry addresses assigned to a specific keyword, select the desired keyword from the Keyword drop-down list. (Note: The Derived Flow Report requires a keyword. You cannot run a Derived Flow Report on a telemetry address.)
You can also combine station numbers with keywords. For example, to retrieve information on pumps at stations 1 and 5 only, select PUMPS from the Keyword list and type 1,5 in the Report Source box.
The Telemetry Address structure in HyperTACII is as follows:
| RTU Type | Station # | Module Letter | Point # |
| DFS | 7 | C | 4 |
| Modbus | 10 | . | 3 |
To run a report on the DFS point above, you would enter 7C4 in the Report Source Box. To run a report on the Modbus point, you would enter 10.3.
Special Notes on the Report Source Box:
Keyword (All reports except Log reports) – Select a keyword from the Keyword list. Keywords are logical groupings of points that allow for the selection of all of a specific type of point (for example, lift station pumps or analog flow meters). Only keywords that have been configured are available in the Keyword list. (Note: The Derived Flow Report requires a Keyword. You cannot run a Derived Flow Report on a telemetry address.)
In this section, you enter the date and/or time span of the report. The From and To fields accept both dates and times (measured in hours).
Special Notes on the Report Period Parameters:
You can add a custom title to your report by typing a text string in the Title box. The custom title is in bold-face text and is centered near the top of HTML reports. Custom titles are left justified on Text reports.
Used for reports that span more than one day. Select Daily or Totalized. Daily produces a report that breaks down and presents the data on a day-by-day basis.Totalized provides aggregate output for the time span.
Select GPM or MGD. GPM produces a report displayed in gallons per minute. MGD produces a report displayed in million gallons per day.
Select a driver number or "all" from the Driver drop-down list to filter the results of a Radio Errors report.
Select Summary or Detailed. Summary generates a report that is listed by address and gives the total for each type of radio error (e.g., No Response, Abort Response, etc.), the total of all errors, and the off-line count and time. Detailed generates a report that is listed by time of error and gives the address at which the communication error occurred and the message that was returned (i.e., 01 or no response).
The Special Features section of the Report Request Form allows you to perform actions such as including a header and date on reports, creating a text of spreadsheet file, and assigning a time filter.
To access these features, click Special Features on the Report Request Form.
Select HTML or Text. HTML generates a report in a table format, which includes graphics, shading, and column headers. Text generates a plain-text report. (Note: Large reports are automatically output in plain-text format.)
Click the Header check box to generate a report with a header that shows the report type, title, and date and time span.
Click the Date check box to produce a report that shows the date the report was generated. Text display reports automatically include the date the report was generated.
Use Daily Filter when you need to gather data over a period of time between specific hours. The time format is 0 to 24 hours, where 0 represents midnight.
Type the report's beginning hour in the Start box. Type the report's ending hour in the Stop box.
For example you need to generate a report for the month of May for the hours between midnight and 6:00 am. You would type "05/01/01" in Report Period's From box and "05/31/01" in the Report Period's To box; type "0" in Daily Filter's Start box; and type "6" in the Daily Filter's Stop box.
Select the Text File Create check box to save your report as a text file (Note: The report is formatted as a Text display report). If this option is selected, you must type a name in the File Name box. The .txt extension is automatically added; you do not need to include it with the file name. Report files are saved on the Hyper Server Module (HSM) in HyperTACII's var/www/html/tmp directory. The files can be downloaded to your workstation with HyperTACII's file download utility. Alternatively, you can use an FTP program to download the files from the HSM.
Select the Spreadsheet File Create check box to save your report as a comma-delimited .csv file. Once saved, this file can be opened in any spreadsheet program. If this option is selected, you must type a name in the File Name box The .csv extension is automatically added; you do not need to include it with the file name. Report files are saved on the Hyper Server Module (HSM) in HyperTACII's var/www/html/tmp directory. The files can be downloaded to your workstation with HyperTACII's file download utility. Alternatively, you can use an FTP program to download the files from the HSM.
Leave this option deselected. It is reserved for use in a future release. To print the report at a local printer, press CTRL + P (these instructions are displayed along the top of the generated report's window).
HyperTAC II's report generator gives you the option of creating a library of reports. For reports that are run on a regular basis (monthly, weekly, daily), this feature enables you to quickly run a report without completing the report form's fields. If a report becomes obsolete, it can be deleted from the library. A saved report can also be easily edited if necessary.
Two types of charts can be output from reports: column (bar) charts and detail (line) charts. Charts are only available from HTML-formatted reports; they cannot be output from plain-text reports. If your report is output in plain-text format because it contains a large amount of data, try reducing the time period or run the report on fewer points.
The example below shows an Activity Report for all points at station 1510 that are assigned to keyword PUMP.
With column charts, you can compare data from a column of a report. Column charts, or bar graphs, are available from Activity, Derived Flow, Pulse, and Analog reports. In these reports, the column headings are underlined and in color instead of plain text [see the column headings Min Ontime, Max Ontime, Total Ontime in the example above (note that the headings Avg Ontime and Times On are not shown)].
When a column heading is clicked, a bar chart of the data from that column opens in a new window. When a report is Daily rather than Totalized, there are separate column headings for each day and a final set of column headings for the totals. The column heading from each section produces bar charts for the data in that section. Time increments are provided along the y-axis of the graph. The x-axis shows each column's corresponding date.
The example below shows the bar graph that results from clicking the Max Ontime heading. This chart enables you to compare the maximum amount of time each pump was running during the selected date/time span.
With detail charts, you can view the detailed activity of a point. Detail charts, or line graphs, are available from Activity, Derived Flow, Analog, and Detail reports. In these reports, row labels on the left side of the report appear underlined and in color to indicate that a detail chart is available.
When a label is clicked, a line graph (similar to a trend) of that row's data opens in a new window. The data for each point is graphed on a separate line and is color coded for easy identification. Status labels (ON/OFF, HIGH/LOW, etc) are shown along the graph's y-axis. Time increments are provided along the x-axis.
The example below shows the line graph that appears when the 15 Card Plate row label is clicked. This chart enables you to compare when each pump was running and when it was off during the selected date/time span.
Data Flow Systems, Inc. | 605 N. John Rodes Blvd., Melbourne, FL 32934 | 321-259-5009 | sales@dataflowsys.com