Question:
How can a report display the minimum, maximum, and average values of a field being stores in a Historic?
Solution:
To do so, follow these procedures:
- Set the report’s query to retrieve the desired field. For example: SELECT Historic.Current FROM Historic
- Create three Data Fields in the report with the following settings:
– Field Minimum:
SummaryFunc = 3-ddSFMin
SummaryGroup =
SummaryRunning = 0-ddsrNone
SummaryType = 1 – ddsmGrandTotal
– Field Maximum:
SummaryFunc = 4-ddSFMax
SummaryGroup =
SummaryRunning = 0-ddsrNone
SummaryType = 1 – ddsmGrandTotal
– Field Average:
SummaryFunc = 1-ddSFAvg
SummaryGroup =
SummaryRunning = 0-ddsrNone
SummaryType = 1 – ddsmGrandTotal
Set these object’s DataField properties with the name of the desired field, exactly as they appear in the SQL query.
