cancel
Showing results for 
Search instead for 
Did you mean: 

Related fields to Maximum Grand Total

0 Kudos

I am creating a subreport where I need some information on the last record created. I am using the Maximum Grand total function to get the most recent Recnum at the bottom. How do I get another field from that record ID in the report footer with the Recnum?

Accepted Solutions (0)

Answers (1)

Answers (1)

DellSC
Active Contributor
0 Kudos

If you sort the data in the subreport so that it's ascending on the create date, then the last record in the subreport will be the most recent. You can then just display the data that you need from that row in the report footer.

-Dell

Sadly this table does not have a create date. I did not design it, and am merely working with what I have been dealt. I did find a solution though. I just had to sort the report by recnum descending and then put the field I was looking for in the header. That returns the top value, which I can then show in the main report.