How to add vertical grand total that repeats on every page

Hi
I need to create a crosstab with max 10 columns on every page ('page break interval' set as 10) and which vertical grand total is displayed on every page (not only on first or last).

Any help would be appreciated.

Find more posts tagged with

Comments

mwilliams

Hi lekiert,

You want the total for the page at the bottom of each column? Or the total for the entire crosstab at the bottom of each page?

lekiert

See attached template.
I want to display 'Grand Total' also on second page, but summary values should be the same as on the first page.

Something like this:
Page 1:
Description, Grand Total, Column 1, Column 2, Column 3

Page 2:
Description, Grand Total, Column 4, Column 5, Column 6

and Grand Total should be summary of all columns.

mwilliams

lekiert,

You can request an enhancement for the grand total value to be able to be repeated on page breaks at http://www.birt-exchange.org/org/resources/bug-reporting/. You might be able to do something with a derived column for each measure that shows the total and then mess with the visibility and your column page break interval to get only the first derived column of a page to show.