If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

forcing two crosstabs to be on the same HTML page

Started by Greg, 27 Sep 2012 02:24:34 PM

Previous topic - Next topic

Greg

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

pricter

Have you tried to change the "Number of Rows" on both crosstabs?

Greg

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  :(

pricter

#3
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. 

bdbits

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.