Print Page - Only displaying every nth row

Title: Only displaying every nth row
Post by: Tsunami on 26 Jan 2012 01:19:56 PM

I have the following requirment:

If there are 100 orders, display every 5 rows
If there are 200 orders, display every 10 rows
and so on.

I was thinking of either ranking or counting and creating a if/then filter based off the rank/count. However, I'm not sure of the syntax or functions available for getting every nth row.

Any suggestions?

Title: Re: Only displaying every nth row
Post by: Grim on 26 Jan 2012 01:27:02 PM

I don't pretend to be any type of report design expert, but you could technically apply the same logic as this to display every 5th row. Just have to tweak the conditional layout stuff.

http://www.ibm.com/developerworks/forums/thread.jspa?messageID=14433501

Title: Re: Only displaying every nth row
Post by: Tsunami on 26 Jan 2012 01:54:22 PM

Ah yes, that's it! I think I can work with that. Thanks a lot.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Tsunami on 26 Jan 2012 01:19:56 PM