COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Greg on 27 Sep 2012 02:24:34 PM

Title: forcing two crosstabs to be on the same HTML page
Post by: Greg on 27 Sep 2012 02:24:34 PM
I have 2 crosstabs inside a block and I don't want them to be split across pages when rendered in HTML, rather I want to scroll down to see them both.  Is there any way to force them to be rendered on the same page? 

Thanks.

Greg
Title: Re: forcing two crosstabs to be on the same HTML page
Post by: pricter on 27 Sep 2012 03:55:38 PM
Have you tried to change the "Number of Rows" on both crosstabs?
Title: Re: forcing two crosstabs to be on the same HTML page
Post by: Greg on 28 Sep 2012 06:36:58 AM
Yes.  That just ensures that each crosstab will display on a single page but it won't force them both to be on the same page  :(
Title: Re: forcing two crosstabs to be on the same HTML page
Post by: pricter on 28 Sep 2012 11:49:13 AM
I have succeed to do that with the following action

1.Put each crosstab in a list.
2.Create a dummy data item for example with expression 1 in the query of the list and the query of the crosstab.
3.Define a master detail relationship between crosstab and list
4.Define the property of the lists "Rows per page" into one.

Also define the  property of the crosstabs "Rows per page" to a large number

I hope this will work for you. 
Title: Re: forcing two crosstabs to be on the same HTML page
Post by: bdbits on 01 Oct 2012 11:30:14 AM
I have found you can remove pagination on the individual object by first selecting the base object (crosstab, list...) in the navigator at the top of the properties pane. Then open the dialog for the Pagination property, check "Repeat every page" and uncheck the other two options. Report Studio under File > Report Properties also has an option for controlling page breaks by data container, though I have not really had to use that myself so you may need to do some experimentation.