The requirement to display the DateTime
when the QtyValue
is max/min in the GroupFooter
section can be achieved with a Custom Aggregate, i.e. a User Aggregate Function
(lets say for the max GetValueForMaxValue
) that receives as arguments Fields.QtyValue
, finds the max/min of the QtyValue
while aggregating along the group values, and returns the corresponding DateTime
The expression in the report will look like:
= GetValueForMaxValue(Fields.DateTime, Fields.QtyValue)
I have attached a sample (CustomAggregate
) demonstrating this approach.
Note that the assembly containing the custom aggregate functions (CustomAggregates.dll
) should be copied to the folder of the Standalone designer - (Telerik Reporting installation folder)\
Report Designer (for example C:\Program Files (x86)\Progress\Telerik Reporting R2 2018\Report Designer
), and registered in its configuration file (Telerik.ReportDesigner.exe.config
) as explained in the Extending Report Designer
Another approach is to display the max/min group values in the Detail
instead of GroupFooter
section. The max/min for the corresponding group can be taken using the scope of the group, i.e.
=IIF(Fields.QtyValue = Exec('group', Min(Fields.QtyValue)), "Min: " + Fields.QtyValue + ", Date: " + Fields.DateTime, "")
This approach is demonstrated in the attached MinMaxSample
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items