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

Random record selection in report studio reports

Started by ajith, 01 Dec 2006 12:36:19 PM

Previous topic - Next topic

ajith

Hello

  I was wondering if there is a way to select records randomly in report studio. For eg: If there are 10000 records and lets say I want to select 5% of the records randomly as the output. Is it possible and how to do it.?

thanks,
Ajith.

sir_jeroen

You could try to generate a random integer... Use that as the source for another tabular model and sort on that random integer...