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

how can i show summary on each page?

Started by bvk.cognoise, 02 May 2011 01:32:53 AM

Previous topic - Next topic

bvk.cognoise

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
Regards
BVK

PRIT AMRIT

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


bvk.cognoise

#2
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
Regards
BVK

PRIT AMRIT

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

bvk.cognoise

#4
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
Regards
BVK

PRIT AMRIT


bvk.cognoise

#6
Hi Prit,

please find the attachment.i have attached xml file.

thanks
bvk
Regards
BVK

kattaviz

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
thanks & regards
Satish Katta

barrysaab


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
Boy! Cognos getting on to me!!!