How to Create Reports Printing Only Value Average at Every 5 Minutes

<< Click to Display Table of Contents >>

 

How to Create Reports Printing Only Value Average at Every 5 Minutes

To do so, users must create a new group in a Report. This group contains a Header and a Footer Section. The general layout is the following:

PageHeader: Contains the title of columns

GroupHeader: Remains empty, but its DataField property is equal to "CLng(E3TimeStamp*288)", because the E3TimeStamp field is the date and time of data in Gregorian format, days since 1/1/1900, in which the integer part is the number of days and the fractional part is hours and minutes. Multiplying by 288 corresponds to a total of five minutes since 1/1/1900. The CLng function converts a 32-bit integer and deletes its fractional part, so that intermediate minutes and seconds are not displayed. This group is then printed each time this number changes, that is, every five minutes. Check the NewColumn and NewPage properties, which must be set to 0: ddNPNone

Detail: Contains SetPoints for table fields. Its Visible property must be set to False, so that each data acquisition that composes a five-minutes average is calculated, although not printed

GroupFooter: Contains the following fields, representing the average of SetPoints:

DataField: Names of table fields, such as in the Detail Section

SummaryFunc: 1 - ddSFAvg

SummaryRunning: 1 - ddSRGroup

SummaryType: 1 - ddSGrandTotal

 

The only exception is for the Date/Time field, which is a standard SetPoint with its DataField property set to "=CLng(E3TimeStamp*288)/288".

ReportFooter: Empty or any other value

 

If this Query is between 00:00 of one day and another one, its result is composed by 288 printed rows with an average of fields at every five minutes.

Was this page useful?