select random entries

[jvolden]

Is there a way to select values from a field randomly. I have a field {table.clientcompany}. I want it to pull values from this field at complete random to display in a report.

Thank you.

 

[BParsons]

Create a formula, Rnd() and drop it into the detail line. This will assign a random value between 0 and 1 to every record. Then do a sort on the formula, either ascending or descending will work. Then you can use conditional formatting to suppress the records you don’t want to see. For example, RecordNumber >= 50 would show you 50 random results.

 

[jvolden]

Thank you, this worked perfectly.