Home DevShare Spreadsheet Automation

Printing merged column value in all pages

Share

by kjawahar

Forum - 10 postsDevShare - 1 post
Posted 16 Aug 2010 - 05:52 PM

(0)  (0)   (168 views)

Merged column value failed to show in subsquent pages when merged region go beyond a page. How to print the merged column in the beginning of the subsequent page when the merged region extends beyond a page?

Birt Version:-2.2

How to print the merged column in the beginning of the merged region to print in the beginning of the subsequent page when the merged region extends beyond single page?

If the rows-per-page is consistent and predictable, you can pass an appropriate key to the merge() function to prevent merged regions from spanning pages.

For example, in your report there are 85 rows per page, use a cell function like:

#write(DaypartDisplayName) merge(DaypartDisplayName & trunc((row() - 1) / 85))

Be careful to keep row heights consistent as messing with fonts can modify it and give you inconsistent results. Also please note that, if the font metrics is different on the users system then the number of rows may change causing unpredictable results.
 

 
Filter More