Need total of last group record over multiple days

[pleashelp]

I am using CR 9.0 and a SQL database. My problem is this:
The report is grouped by Location. Under each location I have a field called final liability. I want to use this field once in each site pulling the last final liabilty record no matter how many days the report is run for. So if the report is run for 6/1-6/3, I want the final liability record for 6/3. I can get this by either putting the field in the group footer or by using a "maximum" formula and putting that in the group footer. That seems to work fine. Now the tricky part is that I need to put a grand total of this final liability for all of the locations. I have tried using a running total, but I can't get it to pick up the last record for the date range. Any other ideas?

Thanks

 

[synapsevampire]

Create a formula like this in the group footer:

whileprintingrecords;
numbervar MySum:= MySum+{table.value}

Now in the Report Footer display the sum using:

whileprintingrecords;
numbervar MySum

-k

 

[pleashelp]

That's great !! Thanks!