I read the threads copied below.  I created a formula RND() and put it into the details section of my report and it returns a decimals starting at 0.00259 to 0.99625.  How can I format the field to produce whole numbers for a select statement of Random <= 25?
Thanks Dorrie
___________________________________________
Myv (TechnicalUser) 27 Jan 04 8:45  
Hello
I've created a Crystal report which returns about 200,000 records.  I now need to select a random sample of 10,000 records from that.  Does anyone have any suggestions?  I've tried using the TopN function but that was unsuccessful.
Can anyone help?

Thanks

Myv

 Thank Myv
for this valuable post!

 
Inappropriate post?
If so, Red Flag it!

 
Check out the FAQ
area for this forum!

 
 

lbass (TechnicalUser) 27 Jan 04 9:04  
Place the following formula (@random} in your detail section:

rnd()

Then use {@random} to sort your report ascending.

Finally, go to format->section->details->suppress and enter:

recordnumber > 10000

-LB

 Thank lbass
for this valuable post!

 
Inappropriate post?
If so, Red Flag it!

 
Check out the FAQ
area for this forum!

 
 

Myv (TechnicalUser) 27 Jan 04 9:33  
Thanks LB for your help but I'm sorry - I don't follow it all.
I've gone into the select expert and the chosen "show formula" and then "formula editor".
My formula at the moment is as follows:
{CBCONHPF.THCRST} = "A" and
{CBBSECPF.BSBSDS} = "Residential" and
{CBCONHPF.THOWTY} <> 3.00 and
{CBCONHPF.THCOMP} = "01"

Where do I put the {@random} command?

I understand your second instruction about format, section, details and suppress.

Finally, where do I enter: recordnumber > 10000?


Thanks in advance

Myv

 Thank Myv
for this valuable post!

 
Inappropriate post?
If so, Red Flag it!

 
Check out the FAQ
area for this forum!

 
 

lbass (TechnicalUser) 27 Jan 04 10:45  
You do not do this in the select statement.

1-Create a formula using the random function by going to insert->formula field->new->name it "random" and enter:

Rnd()

2-Place the formula {@random} on the report in the details section.  

3-Then go to report->sort records and add {@random} as the sort field.

4-Then go to format->section->details->suppress (you don't need to check it)->x+2 button to the right (this is the formula area for section suppression) and enter:

recordnumber > 10000

-LB