How I did this in crystal
Either use a source that limits the employees to your overall match or use the select expert in crystal to limit the data set to all employees in your match
create a formula to generate a "random number"
//RandomNumber
Int(rnd()*1000000)
Place this formula field on the detail row in crystal.
Sort Asc or Desc on this formula field (either sort direction should work)
Conditionally suppress the rows past the 20 you want to show (I also use a parameter to let the user determine the total number of rows to show).
I used a running total (e.g. #EmployeeCount) to do a distinctcount on employee id and suppression in the section expert using that.
{#EmployeeCount}>20
I do not know if the math on that formula works out to technically function as a pure definiton of random but it seems to works for what I needed.
Edited by DBlank - 09 Jan 2012 at 8:11am
IP Logged
