Random Data Selection

[sjc1956]

Is there a way to do a random data selection? I want to run data from a certain month but want it do search randomly for, let's say, 10 records.

 

[IdoMillet]

See faq767-3260

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[gleeb]

The above referenced thread works fine if you have no grouping. I am trying to group by user id and then show a random selection of N records for each group. On the suppression formula no records will print after the first N for the first group. Example:

ID 1
Detail - 15 records here
ID 2
ID 3
ID 4

Any suggestions?
Thanks - RF

 

[gleeb]

Nevermind Answered my own question. Instead of RecordNumber > (?Show_N_Records) use a running count of records that get rest upon group change.

Ex: {#RecCount} > {?Show_N_Records}
Thanks

 

[IdoMillet]

Perhaps I should add this twist to the FAQ... )

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com