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

Number of rows to be displayed in each Report Page

Started by sophiadevi, 28 Jul 2014 03:59:48 AM

Previous topic - Next topic

sophiadevi

Hi ,

I want to display the total row count in each report page for a list report. (Total -48 Rows)
Expected output: Page 1: 20 records, page2 : 20 records, page3: 8 records.

I tried using running-count(dataitem) in List footer.
but it displays Page1: 20 records, Page 2: 40 records , Page 3: 48 records.

Appreciate any of your help in resolving it.

Thanks in Advance.

linbai


MFGF

Quote from: Scognos on 28 Jul 2014 03:59:48 AM
Hi ,

I want to display the total row count in each report page for a list report. (Total -48 Rows)
Expected output: Page 1: 20 records, page2 : 20 records, page3: 8 records.

I tried using running-count(dataitem) in List footer.
but it displays Page1: 20 records, Page 2: 40 records , Page 3: 48 records.

Appreciate any of your help in resolving it.

Thanks in Advance.

...or you could try:

running-count ([Dataitem]) - (floor((running-count ([Dataitem])-1) / 20) * 20)

MF.
Meep!

sophiadevi

running-count ([Dataitem]) - (floor((running-count ([Dataitem])-1) / 20) * 20)

this worked..

Thanks a lot.  :)