Random selection of recods 1

[Fixles]

I have a table full of orders and i need to select 100 at random to be audited. Any ideas how i can do this? Ive searched the web but couldnt find anything. I am using Crystal Reports 7.0 PRO.

Thanks in advance

James

 

[dgillz]

Can you take every Nth record to equal 100 or must if be a true random selection?

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

 

[bdreed35]

Take a look at this FAQ. I think it will help you.
faq149-3261

~Brian

 

[Fixles]

That FAQ is exactly what i am looking for but the Rnd() forumula does not work it maybe for a newer version of crystal.

I may be able to get away with every Nth record. How do i do that?

Cheers for the responses.

James

 

[dgillz]

You need to conditionally suppress the records that are not a perfect multiple of N with the follwing formula:

Remainder(RecordNumber,N)<>0

Replace N with the value you desire.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com