[raffi]

Hello all, here's my problem:
I wanted to add totals per page like in this example :
http://www.birt-exch...otals-per-page/

the problem is I'm not displaying the detail row in my report , because I'm only displaying aggregation data ( I'm using a group header to do that ).

my report looks like this:

header :
group 1 - header : (this group should be able to do page break when group 2 reach 10 rows)
group 2 - header : ( I'm using this group to display aggregates)
group 1 - footer: ( in this row I should display the total per page)
footer : displaying totals here.

So, I can't make group1 group on row.__rownum variable , I want to use another varibale instead which increments when the group 2 creates a row.

I tried to do it with scripting but didnt work. ( I used a variable initialized in "initialize" , set to "0" in "OnPageEnd" , and increments in "OnCreate" of group 2 , and made group 1 group on it )

I can explain more if needed , thank you !

[raffi]

Edit: I could make group 1 group on a variable that increments when group 2 creates a row , but now group 1 only shows it's footer in the last page and not in every page , why in the example shown before the page break happens after the footer creation and now it appears to happen before it not allowing it to show?

thanks in advance for reply

[mwilliams]

Can you create an example with the sample database that shows what you're doing, so I can see exactly what your setup is? Thanks!

[raffi]

Thanks for reply williams
I attached a file to this post , I want to do something similar to this .
I want group 1 footer to show in every page not only last one. thanks !

Attached File(s)

•  balance_sdb.rptdesign (47.46K)
  Number of downloads: 3

[mwilliams]

Take a look at this. I ordered the dataSet by the group and created a count for the groups in a computed column that I used in the outer group to actually get a 10 line group. Then, I added an aggregation and used a variable to store the last page value in. I used all this to display last page's end value on every page and the cumulative total at the bottom. Hope this helps.

Attached File(s)

•  balance_sdb.rptdesign (47.05K)
  Number of downloads: 10

[raffi]

it works fine as I expected Thanks a lot , your help is appreciated !

[mwilliams]

You're very welcome! Always glad to help! Let us know whenever you have questions!