Report showing random records that are 10% of total records 1

[sdzlkds]

Crystal 10 user

I've used the advice from Ibass below to create a report showing a random 10 records, however, the requirement has now changed to "report showing a random 10% of all records (or 10 actual records depending on what is higher)"

I;d be grateful for any advice on whether this is do-able

Thanks

lbass (TechnicalUser) 7 Oct 08 12:43
Create a formula:

rnd()

Add this to your detail section and to report->sort records. Then use a detail suppression formula like this:

recordnumber > 20

-LB

 

[lbass]

recordnumber > maximum([10,.1*count({table.recurringrecord})])

-LB