ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
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
Open in new window
In the group header add a formula to reset the values
Name Reset Variables
Open in new window
In the detail section
Name CalcMaxValueDate
Open in new window
In the group footer
Name DisplayMaxValueDate
Open in new window
mlmcc