COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sunny bachan prasad on 23 Jul 2015 01:01:33 PM

Title: List footer
Post by: sunny bachan prasad on 23 Jul 2015 01:01:33 PM
Hi Cognos guru,
I am working on relational Package and database is oracle.is there is a way to add two list footer one after another.
Thanks in advance.
Title: Re: List footer
Post by: gpollock on 23 Jul 2015 04:38:03 PM
What are you trying to show in each?  You can often just make a summary row, unlock, and move what you want into a row.
Title: Re: List footer
Post by: sunny bachan prasad on 24 Jul 2015 02:27:31 PM
Hi gpollock,
Thanks for your time.
Actually my report has 1 report header,more than 1batch header (It coinatain grouped data)and and for each batcher header we have batch footer(cointain summarized data of  batches) and one report footer(contain summerized data of all the batch footer).I have taken List header and footer to show batch header and footer.But i am not sure how i can show report header and footer.Since we have to show all these in one list only.Please let me know if you need any more information.
Title: Re: List footer
Post by: gpollock on 24 Jul 2015 03:23:09 PM
I think I'm understanding what you're saying.  I just made a simple report, grouped columns and added headers and footers at each group.  I can confirm there's only one header and footer available.

I don't know why you need a second footer, though.  If you need to display more things on the footer, you can always use the unlock feature to add more things to your footer.  After that, you can display things in your overall group total, which is made if you group on the left-most list column.  Is there a data item, or a message that you want to display that you can't do in two footers?
Title: Re: List footer
Post by: NIEK87 on 27 Jul 2015 01:47:29 AM
You can create extra footers by selecting the footer and then clicking: Structure > Headers & Footers > Insert List Row Cells Above/Below.
Title: Re: List footer
Post by: sunny bachan prasad on 31 Jul 2015 06:35:59 AM
Thanks for your suggestion gpollock and Niek87.
I applied a different logic and I get it.First I done sectioning on the list and then I took a dummy data item and again I done sectioning and now if you select whole list and go to structure tab you can see you have option for header and footer.
:) :) :) :) :)