nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

subtotals per page while displaying only groups

raffi

Hello all, here's my problem: 
I wanted to add totals per page like in this example : 
<a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/228-how-to-calculate-subtotals-per-page/'>http://www.birt-exchange.org/org/devshare/designing-birt-reports/228-how-to-calculate-subtotals-per-page/</a> 
 
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 !

Find more posts tagged with

Comments

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 !

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.

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!