|Posted: 09 February 2009 at 4:48am | IP Logged
I'm trying to get a total showing for the records in a detail band, above the display of the detail records. For instance in your example report you show the total for the Chicago sales department as being $9,400. But this is shown after the detail records for the location group.
Is it possible to display the following;
Location: Chicago Total: $9400
11 James 950
12 Blake 2850
Have tried using variables and dataset SUM() but getting either zero or the sum of the previous group.
Any help appreciated.