Add Summary Rows

The Report Studio is still under development and has not officially been released. Be warned that code may change such that reports you create with this pre-release trial version might need to be updated in order to continue working after your next VTScada update.

Until the official release, documentation for the Report Studio will open in response to the F1 key but will not be shown in the menu system. To view a table of contents for the complete chapter, navigate to Report Building (Report Studio)

Use summary rows to display some statistic of all the values in each column.

  • Total
  • Average
  • Minimum
  • Maximum
  • Standard Deviation
  • Median
  • Range
  • Count

Add multiple Summary Rows to display more than one type of operation. Summary values can be suppressed per column where the statistic isn't relevant.

"Count" will return the total number of valid entries in a column, not the total number of non-zero entries. To create a count of non-zero or other specific entries, copy the report output to Excel, where you can do operations such as COUNTIF. Within a VTScada report, Count is most useful for data that has not been aggregated. For example you might create a count of alarm event messages over a given time period.

Create a Summary Row

Click in the [+] bar below the table component. You can add as many summary rows as needed without repeating operations.

Adding a summary row by clicking the plus bar below the component

Adding a summary row

Open Summary Row Properties at any time by clicking on the added summary row.

Available operations include Total, Average, Minimum, Maximum, Standard Deviation, Median and Range.

Selecting the operation for a summary row

Summary rows are designated with a label identifying the operation. This title matches the operation by default, but can be changed in the "Title" setting.

When the report runs, the selected operation will be applied using all the values in the column above it.

Summary Suppression

It doesn't always make sense to include a summary for every column in a table. For example, it wouldn't make sense to total up tank levels or temperatures over time. In these cases, summary row operations can be suppressed on a per-column basis.

A table displays pump flow totals every 15 minutes over the course of 2 hours and the average tank level during each entry period. A summary row displays the total flow for both pumps only. Summary Suppression settings displays 8 unchecked boxes, one per operation. Check the boxes next to the operations you need to suppress.

Both Data Set properties and Data Cell properties permit Summary Suppression. Check the box next to any Summary operation you need to Suppress per Data Set or Data Cell.