COGNOiSe.com - The IBM Cognos Community

Hi,

i have a report which contains 20 pages.my requirement is i want show summary of the report on each page at the top side of column titles on each page how can i do that?please give me the solution?

thanks
bvk

Quotei want show summary of the report on each page at the top side of column titles on each page

If I got your question, Select one of your column in the report,
Menu Bar--> Structure--> Headers & Footers--> List Headers & Footers --> List Page Header/Over all Header
Select newly added row--> Click on 'Split Cell' option from the menu bar--> Unlock the report--> Drag & Drop your calculated item(which would give you the summary result).

You may do a bit of formatting to look it nicer.

If your requirement is different, can you capture a Screenshot of what you want?

Hope it helps?

Thanks

HI Prit,

thank you very much for ur quick reply.but i know the process what you told here.if we do the same process we will get summary only on first page. but my requirement is i have 10 pages in my report.when i click page down in next page also i want to show same summary on colum titles (for example total revenue for report).for more information please find the attachment.and highly appreciate your help.

thanks
bvk

Quotebut i know the process what you told here.if we do the same process we will get summary only on first page. but my requirement is i have 10 pages in my report.when i click page down in next page also i want to show same summary on colum titles

I am not sure if you have implemented the technique correctly though. It should work. Here I have attached the XML, which works fine.

Thanks

Hi Prit,

i followed the same process.now i developed a report with sample package.its showing the same problem.please find the attachment.in first page its showing properly.but in second page its not showing.
do i need to change any other properties?

thanks
bvk

can you attach the XML?

Hi Prit,

please find the attachment.i have attached xml file.

thanks
bvk

Hi Vamsi.

Create a data item, which holds the summary value. then using the Singleton you can display that Summary value in each page of your report.

HTH

The solution i found in IT toolbox might help you.

In case if you still haven't got it.These are the steps

1)Create list footer not the overall footer
2)go to query explorer and create a data item and give expression
running-count([dataitem])
3) Unlock the report and drag and drop the data item created before in the list footer
4) Run the report.

Hope it helps.Thanks