Creating a Grand Total from 3 footers

[rahulmes]

I have 3 data bands with their individual footers. I have a amount column in all 3 data bands and I am using the Sum function in each footer to get the total amount for each band. However, I want a grand total to come at the end of the report which is the sum of all 3 data bands total amounts put together. How can I do this?

Thanks.

[rahulmes]

I solved it myself. I realised that I had to mention the data band name and then sum all three bands, like this:

{Sum(DataBand5, F_Claims.RowAmount)+Sum(DataBand3, O_Claims.RowAmount)+Sum(DataBand2, T_Claims.RowAmount)}

Thanks.

[Alex K.]

Ok.
Let us know if you need any additional help.