creating a summary band

[gr4nt4]

Hi

I have 4 devices in 2 locations and I'm trying to summarise as follows


Averages for location 1 (device 1&2)
Totals of device 1&2
Total of Device 1
Total of device 2


Averages for location 2 (device 3&4)
Totals of device 3&4
Total of Device 3
Total of device 4


I have grouped by location and device and get


Averages for location 1 (device 1&2)

Total of Device 1
Total of device 2


Averages for location 1 (device 1&2)

Total of Device 1
Total of device 2


but cannot figure out how to get the
Totals of device 3&4



Should it be posible with groups or will I have to use a sub report?



many thanks [file name=Image1.jpg size=16591]
Post edited by: gr4nt4, at: 2008/03/18 10:05