Calculating min/max/avg values on a Section Report field.

How can a Section Report in Elipse E3 display the minimum, maximum, and average values of a field that is stored in a Historic?

Solution:

To do so, follow these procedures:

Set the section report’s query to retrieve the desired field. For example: SELECT Current.Historic FROM Historic
Create three Data Fields in the section report with the following settings:

– Field Minimum:
SummaryFunc = 3 – rv2Min
SummaryRunning = 0 – rv2NoSR
SummaryType = 1 – rv2GrandTotal

– Field Maximum:
SummaryFunc = 4 – rv2Max
SummaryRunning = 0 – rv2NoSR
SummaryType = 1 – rv2GrandTotal

– Field Average:
SummaryFunc = 1 – rv2Avg
SummaryRunning = 0 – rv2NoSR
SummaryType = 1 – rv2GrandTotal

Set these object’s DataField properties with the name of the desired field, exactly as they appear in the SQL query.

Calculating minimum, maximum, and average values on a Section Report field.