COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: ajith on 01 Dec 2006 12:36:19 PM

Title: Random record selection in report studio reports
Post by: ajith on 01 Dec 2006 12:36:19 PM
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.
Title: Re: Random record selection in report studio reports
Post by: sir_jeroen on 10 Jan 2007 06:59:06 PM
You could try to generate a random integer... Use that as the source for another tabular model and sort on that random integer...