Calculating Grand total without using table footer.

Chanda

Hi,

As in attached report I want to calculate sub total of orders by Custonmer, and grand total of orders.

I can do this by inserting Aggregation, to do aggr. on "Table" in the footer row.

But in our application table footer are not displayed, if report is previwed through BIRT then it works fine.

when the report is generated through our Application then table footer are not displayed.


So is there any way to calculate grand total without using table footer with help of some functions, script etc.

Please help. (note: we are able to get subtotals0.

Regards,
chanda

mwilliams

Hi Chanda,

You should be able to go into your table's binding tab, and add an aggregation binding to the table. You could sum the entire table or by a certain group. You should then be able to use this binding in the table wherever you'd like. You could also store this value in a persistentGlobalVariable for use outside of the table if that is what you'd like to do.

The table footer is only a location to display the aggregation. You should also be able to put this aggregation in the table header.