Sage 100

Currently on site - Set up a custom shipping label in Crystal and added it to the sales order menu. The label prints fine but I cant print more than one copy at a time. When I execute the program from the menu, I click Setup and then change the number of copies to 2 but only one copy prints. I have tried both a Zebra and a Seagull driver and both give the same result. Any ideas ?

Multi-part printing?

(Assuming it is a form).

Not a form. It is a custom report added to the sales order, custom reports menu. I am using a Seagull driver, but also tried a Zebra driver and still the same issue.

Try creating a second printer in windows that has the two copies, and then choose it ?

@JeffFiddelman I cant find where to set the number of copies in the Seagull print driver.

Duplicate the output within the Crystal Report? (Label print drivers are always fussy).

If I copy the report to the desktop and run it then multiple copies print fine.

It must not be the driver. It has to be something Sage 100 related. I will call Sage (reluctantly).

print from preview work OK?

@alanniergarth On a preview, if you click Setup then choose 2 copies, only one label is presented for preview.

2014.1.4 Unsupported version and Sage is no help. ""It is a retired version and also they are not current on the product updates."". "".... and I don't see any knowledge base articles."".

I would go back to setting up a 2nd windows printer, using the zebra driver, that is set to 2 copies.....

@JeffFiddelman I already have 2 printers set up for the same physical printer - one has a Zebra driver and the other has a Seagull driver - neither work from Sage when printing more than one copy. The Zebra driver landscape mode also doesn't work. At least the Seagull driver will print in landscape mode.

I go back to the idea of having multiples produced by CR in the .rpt... We've done some odd things to work with a UDF driving different quantities for line level labels, but getting a hard-coded two copies should be rather straight forward. Even a pop-up parameter for the count should be easy enough, without having to deal with print driver issues.

This report uses SO_SalesOrderHeader. We could install the report designer on each workstation that needs to print labels and have the user print out of Crystal but management doesn't want that and we would also need to buy more Designer licenses. @KevinMoyes Can you give me a bit more info on what you link the parameter to to make multiple copies print?

The easiest path would be if everything fits within one section of the report (eg: Details a)... then simply copy / paste everything to Details b, with a forced page break between them. If that is not possible, (with grouping / multiple sections), we've set up a UDT with a sequence # as key, linking that to the report's main table with a <> column link (meaning a purposeful Cartesian product). It's basically a trick to get multiple copies of the main table data into the report. Then use suppression to only print when the UDT key field is less than or equal to your desired number of labels, with forced page breaks as needed.

Thanks Kevin. I saw a similar table solution in a Google post.It didn't mention how to create the column link which is I am sure the ""trick"".

In Database Expert, double-click on your fake link to the UDT (with two rows)... then:

Thanks a million Kevin.