Page break on crosstab

Hi,

I would like to know if it's possible to set a page break on dimension added dynamically (by a script) and how to do this if it's possible?

thanks in advance,
Maxwelll

Find more posts tagged with

Comments

mwilliams

Sure, you can force a page break on a crosstab in script. Can you be more specific on what you're wanting? Are you wanting to page break a dimension depending on user input or what decides?

Maxwelll

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="96845" data-time="1330376293" data-date="27 February 2012 - 01:58 PM">
Sure, you can force a page break on a crosstab in script. Can you be more specific on what you're wanting? Are you wanting to page break a dimension depending on user input or what decides? </blockquote>
 
 
Thanks for the fast response! 
 
In fact I add time dimension with differents levels depending on user input. for exemple the user can aggregate data by year or month or week ... if he chooses month aggregation during a period on several years i would like to make a page break every year, for an aggregation by day i would like to make a page break every month and so on ... I don't see where i can do it and on which elements !? 
 
thanks in advance, 
Maxwelll

mwilliams

Can you reproduce what you're doing with the grouping, using the sample database? This way I can see how you're adding the extra groups by parameter, so I can show how to add the page breaking in your example. Thanks!

Maxwelll

Hi,

Sorry for the belated reply,

I reproduce what I'm doing with the grouping, using the sample database. I attach a zip file to this post
including both .rptdesign and .rptconfig. In this example the user can choose an aggragation and in the before factory I insert dimension depending on user's choice.

thanks

mwilliams

Take a look at this example. I modified your version. The dynamic grouping being added in the beforeFactory made it a little tougher. There is an easy way to script this if the crosstab has static dimensions. You can set the pageBreakInterval in the onPrepare of the crosstab. That didn't work with this example, so I had to grab the columnLevels for the crosstab in the beforeFactory, after you set your dimensions. Let me know if you have any questions.

Maxwelll

<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="97460" data-time="1331259259" data-date="08 March 2012 - 07:14 PM">
Take a look at this example. I modified your version. The dynamic grouping being added in the beforeFactory made it a little tougher. There is an easy way to script this if the crosstab has static dimensions. You can set the pageBreakInterval in the onPrepare of the crosstab. That didn't work with this example, so I had to grab the columnLevels for the crosstab in the beforeFactory, after you set your dimensions. Let me know if you have any questions. </blockquote>
 
 
Hi! 
 
Thank you for your example it's exactly what I want. I done it in my report and it's work fine. 
Thanks again!

mwilliams

Great to hear! Let us know whenever you have questions!