COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: naveen_hadagali on 31 Jul 2007 08:26:11 AM

Title: Page Total
Post by: naveen_hadagali on 31 Jul 2007 08:26:11 AM
Hi All,

I am using Cognos 8 .. I have report which contains  repeater table with data items like line num,service no,amt.
Now this repeater table is of 5 across and 10 down.

There is a prompt for Customer ...if you select a Customer then the details for that Customer will be in the page ..this info may run more then page as each page need to have 50 blocks .so the method you said was not working.

Ex;
if the dealer selected has 100 card no , then 50 in page 1 and 50 in page 2
.. my requirement is to get separate total for ach page.

Kindly guide me in this,,,,

Regards
Naveen
Title: Re: Page Total
Post by: DSR on 02 Aug 2007 06:20:22 AM
Hi Naveen

I tried this but I am getting some near solution but it is giving some problem

try this


running-maximum(running-total( [amount]))

Here we are displying only 50 records for each page ,But it is taking the current record also in the sum i.e 51 record also for first page. Any way try this once if you get any solution to remove 51 record from the total post that answer.

Thanks

Sanjeev
Title: Re: Page Total
Post by: naveen_hadagali on 02 Aug 2007 08:18:33 AM
Hi Sanjeev...

Could you plz give wat u used and wat u did.....
Title: Re: Page Total
Post by: DSR on 03 Aug 2007 01:57:13 AM
Hi Naveen

I got currect solution for ur requirement ,But here we need to use page_total at the page footer only.


Here I am attaching the XML try this once

Thanks
Title: Re: Page Total
Post by: naveen_hadagali on 03 Aug 2007 05:05:02 AM
Thanks a lot sanjeev.....
Title: Re: Page Total
Post by: naveen_hadagali on 03 Aug 2007 08:43:38 AM
Hi sanjeev,

It works fine and i need to do some changes ...Now it gives total of 50 in first page and in the second page it 's giving total as 50 of page 1 +50 of second page...
I need like separate totals
Ex:
Page 1 --pagetotal of 1-50
page 2 --pagetotal of 51-100
page 3 --pagetotal of 101-150


Can you help me in this


Regards
Naveen
Title: Re: Page Total
Post by: DSR on 03 Aug 2007 08:58:19 AM
Hi Naveen

We can do this requirement by using the List.Try this by using the following attached XML and make like repeater table by using textitems in between.


Thanks
Title: Re: Page Total
Post by: naveen_hadagali on 04 Aug 2007 12:41:24 AM
Hi Sanjeev,

The attached XML file is not opening and it is saying XML String could not be parsed...Could you plz attach the new xml file plz ASAP....  Thanks A lot
Title: Re: Page Total
Post by: DSR on 05 Aug 2007 07:54:54 AM
Hi Naveen


Try with this attachment.

Thanks