COGNOiSe.com - The IBM Cognos Community

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

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

Hi Sanjeev...

Could you plz give wat u used and wat u did.....

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

Thanks a lot sanjeev.....

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

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

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

Hi Naveen


Try with this attachment.

Thanks