COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: cognos05 on 04 Feb 2015 11:19:12 AM

Title: crosstab and list in same page
Post by: cognos05 on 04 Feb 2015 11:19:12 AM
Hi,

I have a report with a cross tab and list to be showed in same page.Right now my crosstab is in the first page and then I need to page down to see my list.

What properties should I set to have them in the same page.

Thanks,
Nithya
Title: Re: crosstab and list in same page
Post by: Robl on 04 Feb 2015 11:47:51 AM
I would hazard a guess you're getting a multi page thing because of the number of rows in the list.

Try making a 2 row table.
Put a block into each row and set the block to have scroll bars when neccesary.
Set the blocks to be 10 cm high each (or whatever fits nicely on your screen)
Then put the list and crosstab into a block each.
Then run it and see what it looks like.

Another approach could be to change the row limit on the list so the entire list contents appear before the crosstab.
How many rows of data are there in the list?
Title: Re: crosstab and list in same page
Post by: cognos05 on 04 Feb 2015 01:37:43 PM
I want list to be shown at the bottom. List has 8 rows and Crosstab has around say 500 rows.
Even I f I set rows per page property of crosstab to 1000, it will show me the list in the second page.

Thanks,
Nithya
Title: Re: crosstab and list in same page
Post by: CognosPaul on 04 Feb 2015 01:45:03 PM
File->Report  Properties->set Page break by data container for interactive HTML to Yes
Title: Re: crosstab and list in same page
Post by: cognos05 on 04 Feb 2015 01:47:53 PM
Thankyou ! this  worked.