Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sophiadevi on 28 Jul 2014 03:59:48 AM

Title: Number of rows to be displayed in each Report Page
Post by: sophiadevi 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.
Title: Re: Number of rows to be displayed in each Report Page
Post by: linbai on 28 Jul 2014 05:53:04 AM
try this :
RowNumber ()-(PageNumber ()-1)*20
Title: Re: Number of rows to be displayed in each Report Page
Post by: MFGF on 28 Jul 2014 05:58:18 AM
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.
Title: Re: Number of rows to be displayed in each Report Page
Post by: sophiadevi on 28 Jul 2014 06:28:21 AM
running-count ([Dataitem]) - (floor((running-count ([Dataitem])-1) / 20) * 20)

this worked..

Thanks a lot.  :)
Text only | Text with Images