Selecting Nth Record for Printing 1

[ihda]

Crystal 8.5

How can I print data from a table based on every nth record in the table?


Thank you.

 

[dgillz]

You cannot select every Nth record, but you can conditionally suppress the records that are not every Nth record.

Right click the details section and select format section. To the right of the suppress checkbox in a X-2 button. Click it and enter the following formula:

Remainder(RecordNumber/N)<>0

substitute a real number for N, and this will supress every record that is not perfectly divisible by N.

If you are subtotalling anything from these records, you will have to write a formula with variables or use a running total field set to evaluate on the same set of conditions as your suppress formula.

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

http://www.trianglepartners.com

 

[ihda]

Thank you for your help. I'm able to produce the report by every 1,000th record.

Thanks again.

 

[dgillz]

I was actually tasked once to do a random 5% report so my initial reaction was to take every 20th record. They came back and said every 20th record is not the same as a random 5%, which could actually pick consecutive records if you choose the numbers randomly.

So I was able with a little help from Ken Hamady to actually get a random 5% report.

If anyone is interested in a report that randomly picks 5% of the records as an example of the report logic, let me know and I'll email it to you.

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

http://www.trianglepartners.com

 

[sewilj]

dgillz

I would be interested in a copy of the report as I have been tasked to produce a report that users can select random cases from. Your report would do away with the users having to select the random cases. My email is lewis.johnson@birmingham.gov.uk.

Thanks in advance

Lewis
United Kingdom

 

[IdoMillet]

Have a look at: faq767-3260

Cheers,
- Ido

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

http://www.MilletSoftware.com