Insert timestamp data field of max summary

There are 3 ways to do this

First would be to use a SQL expression to select the date based on the group values and the max value.

Second would be to use a command for the data source and do it in the SQL.

The thirds method is to use a set of formulas.  DO you want the last date with the max value or just any date that corresponds to the max value?

Basic idea.
Add a formula to the report header.
Name Declare Variables

WhilePrintingRecords;
Global NumberVar MaxValue;
Global Date Var MaxValueDate;
''

Select all Open in new window

In the group header add a formula to reset the values
Name Reset Variables

WhilePrintingRecords;
Global NumberVar MaxValue;
Global Date Var MaxValueDate;
MaxValue := 0;
MaxValueDate := Date(1900,1,1);
''

Select all Open in new window

In the detail section
Name CalcMaxValueDate

WhilePrintingRecords;
Global NumberVar MaxValue;
Global Date Var MaxValueDate;

If ({Field2} > MaxValue  then
(
      MaxValue := {Field2};
      MaxValueDate := {Field1};
      '';
);
''

Select all Open in new window

In the group footer
Name DisplayMaxValueDate

WhilePrintingRecords;
Global Date Var MaxValueDate;
MaxValueDate 

Select all Open in new window

mlmcc