COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: LisaG on 12 Mar 2009 12:18:41 PM

Title: Report footer - only last page
Post by: LisaG on 12 Mar 2009 12:18:41 PM
Hello All,

Cognos 8.3 SP2 - Oracle

We are trying to create a report footer that only appears on the very last page.  What seemed logical doesn't seem to work.  We created a boolean condition for the last page using the following:  PageCount()=PageNumber()

Then we applied that to the list and told it to only render for true.

Only it doesn't work.  It renders for all pages.  Just checking to see if it actually does supress rendering, switching it to render only on Falses causes it to never show up.  The page number is definitely not equal to the page count on the pages before the last page (displaying page x of y)

Any ideas?  I don't need to make this technique work, but I do need a technique to create a true "report footer" in some shape or form though.

Thanks in advance

Lisa
Title: Re: Report footer - only last page
Post by: Gollapudi on 13 Mar 2009 01:31:01 AM
Hi,

Dont do any conditional formating here, let the reoprt footer as it is.. and move all your report design part from "Page Body" to "Page Header" and say 'Box type' none for your "Page Body", then the report footer will appear only once,  i.e. end of the report


Thanks,
Gollapudi.
Title: Re: Report footer - only last page
Post by: DanSev on 16 Mar 2009 03:04:21 PM
This works with a list report -
in the structure menu select headers and footers and in the sub-menu select headers & footers.

Then select Overall Footer. - This footer will only be displayed at the very end of the list.
If you are not working with lists, you can in theory put the object with-in the list as a master detail, and have the footer, or you could create a second report page and put the footer there (all of page 1's value show, then page 2s values).

Title: Re: Report footer - only last page
Post by: kris102 on 17 May 2013 01:05:50 PM
Hi,

I'm working on the same exact issue. Did you by any chance find resolution for this?


Thanks,
Kris