Print 4 copies of report

[dgillz]

Has anyone ever done this?

We have a 4 part picking ticket form and if the output is 3 pages we need pages 1,1,1,1 then 2,2,2,2 then 3,3,3,3. Right now this is 1,2,3 - 1,2,3 - 1,2,3 - 1,2,3.

Any advice appreciated.

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

http://www.trianglepartners.com

 

[lbass]

dgillz,

Do you have any consecutive number field that you could use to group on based on the number of records that fit in one page? If so, you could create a formula {@page}:

if {ticket.number} in 1 to 50 then 1 else
if {ticket.number} in 51 to 100 then 2 else
if {ticket.number} in 101 to 150 then 3 else
if {ticket.number} in 151 to 200 then 4

Then group on this and check "new page before" in format section->group header (adding "Not onfirstrecord" to the formula section).

Then create three subreports identical to the main report and using the same group formula. Use this formula also to link the subreports to the main report on the main report formula field, and then place the subreports in separate group footer sections. In the main report, go to format section->group footer (for each section a - d) and check "New page before."

For the page number just drag the formula you are grouping on {@page} into the page footer.

-LB

 

[IdoMillet]

Don,

If you schedule the printing from Visual CUT, just set the number of copies to 4 and uncheck the "Collate" option.
I just tested this and it produces 1,1,1,1 then 2,2,2,2 etc.

If you are doing this from Crystal, just set the Collate property in the Printer options.

Cheers,
- Ido

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

http://www.MilletSoftware.com