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

Break List to second page after 15 rows

Started by jabs, 11 Feb 2015 10:39:45 AM

Previous topic - Next topic

jabs

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

Lynn

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.

BigChris

That is elegant in its simplicity...really like that! I'll have to keep that in mind for future use.

jabs