COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: GerritZ on 03 Jun 2015 01:56:07 AM

Title: List footer should not appear on last page (PDF)
Post by: GerritZ on 03 Jun 2015 01:56:07 AM
In my report I use the running-total function to display the "Carry Forward" amount on the bottom of each page. This variable is placed in the list footer. It works fine for all pages. However for the last page, the list footer (or the content) should not be displayed (because it is printed below the grand total). The print should be in PDF. I tried a number of things with conditional formatting or queries, but nothing seems to be working (page count is not available in PDF, other variables seems not to be correct or has the same value on all pages)
Can anyone help me out?
Is there maybe another way to display carry forward on the bottom of each page, except the last one?

Thanks,
Gerrit
Title: Re: List footer should not appear on last page (PDF)
Post by: GerritZ on 18 Jun 2015 10:02:00 AM
Is cognos able to handle situations where information should be printed on all page, except the last one?
Title: Re: List footer should not appear on last page (PDF)
Post by: BigChris on 18 Jun 2015 10:20:48 AM
The easiest way to do this is to have two pages in your report, and omit the bits you don't want on the 2nd page.
Title: Re: List footer should not appear on last page (PDF)
Post by: BigChris on 18 Jun 2015 10:23:07 AM
Pressed reply too quickly - the bit I missed out was that you'll need to work out how much data is going to appear on the first page and how much on the second...possibly by specifying the number of rows on the page.