I would like to do the following:
I have a main report which will display certain totals. Also I need to find certain dates from other tables using sub-reports. Sub-report: reads table-B. For every record-type "B" on Table-B, I need to find the latest date from these records. Then I need to bring this max-date back to the maijn report and print on the group-footer line.
I know how to use shared variable, but I don't know how to store a "maximum date."
Can you help?