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; } } }

How to use carryover values from a table

germobirt

Hi, using Birt 4.3.1 I want to figure out ways to use carryover values from tables over multiple pages.
 
How and where can I use aggregated values (sum/avg) if a table stretches over multiple pages.
 
1. Can I show such values in a last line of the table before the page break?
2. Can I show such values in a first line of the table after the page break?
3. Can I show such values in a row(cell) under/outside the table before the page break?
4. Can I show such values in the footer/header area of the masterpage?
 
Best regards

Find more posts tagged with

Comments

pricher

Hi,
 
I have attached an example that shows how you can display the carryover value of a running sum on each page of a report. I have used two techniques: 1) display a page variable in the header and footer of the master page; 2) display a persistent global variable in a label inside the detail row of the table. The use of two different techniques is due to the way events are generated in BIRT. 
 
Hope this helps,
 
P.

germobirt

Hi,
 
thanks it helped a lot, but it seems to me that it's propably not possible to show the carryover values in the footer of the current page (where the current running sum is calculated, or?
 
The content of a page variable is obviously read on every OnRender() event when a new footer is created.
And that is before any running sums are calculated.
 
Can you confirm that?
 
best regards

pricher

Hi,
 
To show the carryover value in the footer of the current page:
 
1) Create a new page variable, carryOverToPrintFooter;
 
2) Set the value of carryOverToPrintFooter in the onPageBreak method of the table:
 reportContext.setPageVariable("carryOverToPrintFooter", reportContext.getPersistentGlobalVariable("carryOver"));
<div> </div>
3) Display carryOverToPrintFooter in the footer area of the master page
 
I have attached a modified sample report.
 
Hope this helps,
 
P.

germobirt

Thanks, but I got this already.
 
What I would like to see in your example is the running sales values
3.531.083,93 in the footer of the first page
7.029.476,52 in the footer of the 2nd page
 
Is that possible?
 
In your example the running sales value of the first page is displayed(carried over) in the footer of the 2nd page.
 
best regards

pricher

The example I just sent you does that already!