Record Selection

[ecugrad]

We have an Audit system connected to our Crystal Reports. On the record selection, I only want to bring in a random 60% of all audits done on each employee. How would I go about only bringing back 60% of the records for the employees?

Thanks.

Mike

 

[lbass]

Follow Ido's suggestions in FAQ727-3260. Instead of recordnumber, use {#cntwingrp}--a running total where you count a {table.employee}, evaluate for each record, reset on change of group (employee).

-LB