COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: gosoccer on 12 Feb 2016 03:49:48 PM

Title: Crosstab Keep Breaking the Page (Report Studio, DMR) 10.2.1
Post by: gosoccer on 12 Feb 2016 03:49:48 PM
Hi,

Well, my Crosstab is acting very crazy. It keeps breaking to a new page while it really doesn't need to.
I have change the Height on the containing Page, Table, Block, and nothing is stopping it from breaking
the bottom of the page to a new page. It's just a crazy crosstab with no sense.. :o :o

So, if anybody knows a trick, pls let me know.

I greatly appreciate your time.
Title: Re: Crosstab Keep Breaking the Page (Report Studio, DMR) 10.2.1
Post by: Nike_BA on 12 Feb 2016 04:32:04 PM
You can try setting the "Rows Per Page" property on the Crosstab to a large value. I believe the default is 5000 when no value is entered, which generally should prevent forced pages breaks if you are expecting your results to fit on one page, depending on your output selection. But entering a large value like 10000 has worked for me in the past. Also, if your Crosstab is breaking on a sectioned group, check under the Structure menu to see if you have set a page break or selected to break according to master/detail data. If either of those do not resolve the break, screenshots might help to identify other potential solutions.