COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: lee on 06 Dec 2009 09:45:22 PM

Title: Remove the table from second page onwards
Post by: lee on 06 Dec 2009 09:45:22 PM
Hi All,

Our report is created with Section and applyed pagebreak on the section that means each section will display in a new page. Above the section a table with standard text is inserted which needs to be displayed only in the first page.

The issue is when we apply page beak for section, the table is repeated on the every page. How can we hide the table from second page onwards.
 
Advance thanks,
lee.
Title: Re: Remove the table from second page onwards
Post by: lee on 17 Dec 2009 10:49:02 PM
This is a critical issue, Could you please provide solution ASAP.

Advance thanks,
Lee
Title: Re: Remove the table from second page onwards
Post by: CognosPaul on 18 Dec 2009 05:35:56 AM
This is an issue that I've had previously with tables. A workaround is to create a list, hide the body of it, and stick the table inside the list title. The list, and therefor the table, will only render for the first page.
Title: Re: Remove the table from second page onwards
Post by: dinos on 18 Dec 2009 11:32:49 AM
Place the table in your page header section of your report.  Then, select the table object, and in the Pagination properties of the table, de-select 'Repeat table rows on page break'.
Title: Re: Remove the table from second page onwards
Post by: IceTea on 21 Dec 2009 02:21:17 AM
I tried this in 8.4 and 8.4.1, a table in the report header and a second time the table in the normal report area.

In both tries, the table is repeated on every single page with HTML-Output. If i do a PDF-output, your hint is working perfectly.

What's the trick for not repating the table-content with HTML-Report-Output?  ???
Title: Re: Remove the table from second page onwards
Post by: CognosPaul on 21 Dec 2009 02:53:37 AM
In HTML output you can use a page number variable. Use a Bool: PageNumber () = 1. Set the list's style variable to that, and set box type to none on No. The odd thing is that, at least in my quick test, a render variable didn't work on the list, but did work on another table.