COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: jabs on 11 Feb 2015 10:39:45 AM

Title: Break List to second page after 15 rows
Post by: jabs on 11 Feb 2015 10:39:45 AM
Hi all,

I am creating client invoice statements. Page 1 has two sections. The first is the header, with company and client address info, etc. The second part is a list containing the invoices.

If a client has a large number of invoices (more than 15), the remaining invoices spill over into a second page, which is a copy of the first. Since it is a copy, it has all of the header information, which I don't want. Also, at the end of page 1, I want to add some text like "invoices continue next page" or similar.

How do I tell the list to break after 15 results, add some text (only when it breaks), and continue on a second page?

Thanks,
Joe
Title: Re: Break List to second page after 15 rows
Post by: Lynn on 05 Mar 2015 04:17:24 AM
Assuming your source is relational, you can add a data item to the query for row count and then conditionally style your "continued" message based on that value. You could try using a second page layout for the continued portion and omit the header from that. Set the page to only render when the maximum of your row count exceeds 15. Set the list on the second page to not render the rows where row count is 15 or less.
Title: Re: Break List to second page after 15 rows
Post by: BigChris on 05 Mar 2015 09:43:32 AM
That is elegant in its simplicity...really like that! I'll have to keep that in mind for future use.
Title: Re: Break List to second page after 15 rows
Post by: jabs on 10 Dec 2015 11:49:27 AM
Thank you. That is a great idea.