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

Only displaying every nth row

Started by Tsunami, 26 Jan 2012 01:19:56 PM

Previous topic - Next topic

Tsunami

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?

Grim

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
"Honorary Master of IBM Links"- MFGF
Certified IBM C8 & C10 Admin, Gamer, Geek and all around nice guy.
<-Applaud if my rant helped! 8)

Tsunami

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