Nth select

[NTSGuru]

is there any way to perform an Nth select in CR8?

i.e. select 1 out of every 20 records

TIA
Fred [sig][/sig]

 

[kenhamady]

No directly, but you can tell Cyrstal to only display one out of every 20.

Put the following formula under the Suppress condition of the details section:

Remainder (RecordNumber, 20 ) <> 0 [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]

 

[NTSGuru]

Rock on man... that's just what I needed. Thanks a ton.

Fred [sig][/sig]