Displaying table header and table footer in all the pages

Hi

The report am developing has a table whose values run into multiple pages.
But the issue is, the table footer appears only in the last page at the end of the report.

My requirement is to have the table footer in every page. Is there any way to enable the table footer in all the pages of the report?

For table header also the same requirement. Is it enough if i just check the "Repeat Header" option under Page Break in Properties section?

Need assistance in this matter...

Find more posts tagged with

Comments

JasonW

For table header just use the Repeat Header checkbox.
BIRT does not have the option for footer, but you can use page variables and create a footer in the master page which will display on all pages.

Jason

kumaresh

Jason

The table footer i use has the sum of the values from the table columns. But in master pages, i think we can't use data set values, right?

JasonW

Yes you can, by using a page/report variable. If the value is the same on every page, then use a report variable. In the table footer for the element that holds the total for all pages put an onCreate script like this:

reportContext.setPageVariable("totalForAllPages",this.getValue());
Create a report variable named totalForAllPages
add the report variable to the master page footer. See attached example.
Note the example shows a page variable as well and was built in BIRT 3.7.

Jason

Mani_K

Thanks

Mani_K

Hi Jason,

I have set repeatHeader properties as TRUE. But table headers are not repeating for all pages in excel. Headers are coming only in first page. I am using BIRT 3.7 version.
Please refer the attachment for the details.

Note: Please ignore my previous post.

Thanks,
Mani

Shravan Kumar

<blockquote class="ipsBlockquote" data-author="JasonW" data-cid="81674" data-time="1313689375">
<div>
Yes you can, by using a page/report variable. If the value is the same on every page, then use a report variable. In the table footer for the element that holds the total for all pages put an onCreate script like this: reportContext.setPageVariable("totalForAllPages",this.getValue()); Create a report variable named totalForAllPages add the report variable to the master page footer. See attached example. Note the example shows a page variable as well and was built in BIRT 3.7. Jason
</div>
</blockquote>
Hi Jason, i have tried your example for the same requirement. i need to have page wise totals so used your advice of master page footer. but looks like the table aggregation "oncreate" script getting called only once but not for every page( reportContext.setPageVariable("totalForAllPages",this.getValue()); - it called only once). in that case how would your solution of using the page variable in masterpage footer would work? could you please advice me further if any tweak available.
 
my requirement is to display page wise total's(sub-total) which are obviously not same as table footer total values.
 
table footer value = sum of all page wise totals.
 
I appreciate your quick response.