Conditional Page Break in Table depending on total number of rows

Hi,
I have a requirement. I am using XML Data source. But each of my XML can have variable number of data set rows. Some have 45 and some 36. (this number can be derived by using the COUNT function on a column called item_seq_num).
What I need is- a page break at exactly 1/3 and 2/3 of the total number of rows. 
For e.g :- 
@15 and 30 if there are 45 rows total 
and 
@12 and 24 if there are 36 rows total
 
How can I achieve this? I am using BIRT RCP Deigner 4.4.2. 
Thank you.

Find more posts tagged with

Comments

mwilliams

One thing you could do would be to set up a dynamic page break script. All you'd need to do is an aggregation to give you the row count and one to give you a running count. In the onCreate of your detail row script, you'd use these two fields to dynamically set the pageBreakAfter. this.getStyle().pageBreakAfter = "always"; OR this.getStyle().pageBreakAfter = "never"; Hope this helps. If you need a simple example of this, let me know.

keerthink

Where do I create the aggregation?..in the detail row? If I already have a data element that acts as a serial number, do I need a running count?
I am also not sure how to use the aggregation count in the script and divide it by 3.
I guess I could use a simple example..
 
Thanks

mwilliams

I guess you wouldn't need the running count since the table already keeps a row number. I'll create a simple example and attach it.

mwilliams

Take a look at this example. I have a parameter that limits the number of results returned in the query. That's all it does. It is not used to determine the page break, so you don't need to have this. In the data set editor, you'll see the computed column that gives the count of rows. The page break interval of the table is set to 0 since we'll control this manually. Finally, the script in the onCreate of the detail row figures what a section should be, gets the current row number from the table and determines if we should page break or not. Hope this helps. Let me know if you have questions.

keerthink

Yes..this does it!!!
Thank a bunch!

mwilliams

Great! Glad to help. Let us know whenever you have questions.