A way of printing multiple copies of documents

It's not unusual to need multiple copies of some documents - for example, 3 copies of a despatch note, 1 for the office, 1 for the customer, 1 for the haulier.

This Knowledge base article suggests setting it in the printer driver, but it can also be done in the report layout.

This is how to do it for SOP despatch notes, but a similar technique can be used for most documents:

1. In Report / Joins, add SYSModules as a Static table

2. Add a new group header and footer (Sections / Add Section) for SYSModules.SYSModuleID

Use Sections / Move Up to move the new SYSModules.SYSModuleID header above the 1st section (SOPDespatchReceiptID Header)

4. Add another new section with the same expression as the documents first section ( SOPDespatchReceipts.SOPDespatchReceiptID)

Move that above the SYSModules.SYSModuleID header

5. Set all 4 sections (headers and footers) to Visible: False

4. In Report / Criteria. add a new criteria for SYSModules.SYSModuleID to control the number of copies:

For example, if you need 3 copies, set the Default Value to "Between 1 and 3"

5. (optional) If you want the name of the copy to be printed, add an expression like this to the report:


SYSModules.SYSModuleID=1?"Office":
SYSModules.SYSModuleID=2?"Customer":
SYSModules.SYSModuleID=3?"Haulier":
SYSModules.SYSModuleID + "th Copy"

That's it: each despatch note will now be printed 3 times - or as many times as you like

  • Thank you Geoff for your suggestion on printing multiple copies.

    As there is no specific option in Sage report designer to automatically print multiple copies and the above method has not been tested by R&D, This knowledgebase article was created by Sage as a workaround. The steps in Sage knowledgebase article would be easier to follow by end users, IT or anyone who does not have report design experience.

    Kind Regards.

  • Utter genius.  Just implemented this on a bespoke process where the customer wanted multiple copies of the same report.  Once i figured out the page breaks it worked like a charm, and as i'm running the report from code, i can control the copies within that.  

    Brilliant!

  • I need the equivalent of the page titles as denoted above like Office, Customer, Haulier etc. copy. However need to use it like a conditional format as I need them to print in different colours dependent upon the copy i.e. on copy 1 (i.e. page 1) print office copy in red text, on page 2 print customer copy in Blue etc. but struggling to get it to effectively see that the SYSModuleID=1 (I have even added the sysmodule field pnto the document to ensure I can see whether it is 1,2 or 3.

    Thanks

    Adrian