Sage 100

Printing on multi-color paper... Client is printing on 4 color paper for invoices, WYPG, WYPG, not WWWW, YYYY, PPPP,GGGG. We have the first form going to the customer, then the next 3 are internal and print a comment about the commission that cannot print on the customer form. SO, using Multi-Part to conditionally suppress based on the Shadow Text. First line prints 1 copy, next line prints 3. Unfortunately, it prints as WWWW,YPG, YPG, YPG (which doesn't correspond to how the paper actually is). You can't uncheck Collate for a single copy. Any work arounds? Quick Print works, but would like to print in batches. And a free drink at Summit to anyone who actually understands what I just typed. YIKES.

I understand your post just fine. I'll take a Martini, please........... :-)

Oh, a solution? Nah, I don't have one for ya........ :-)

Is the paper in 1 tray WYPG or 4 trays? The only time I've done this paper was in 1 tray and we needed the copier/printer company to put a command into the printer for this type of collating.

Oh, DANG, @NancyHanson - it's in one tray. And @LouWagner - I'm gonna make you prove that you understood - AFTER that Martini. :-)

I give no warranties on what I'll say after a Martini. :-)

If you run this to Paperless office, is the order correct? If so, then you could print from PPO.

Came up with a solution, a Cartesian Join. 1. Ditch the multi-part and instead create a UDT with just the key field, since you only need 4 copies, the length of the key field can be 1. 2. Create 4 records in the UDT, enter 1, 2, 3, and 4 as the value. 3. Add the UDT to the menu so crystal can see it. 4. In the report, add the UDT but do not create any joins between the work table and the UDT. 5. Create a new formula, in the formula, use the following ""{SO_InvoiceWrk.InvoiceNo}+{SO_InvoiceWrk.HeaderSeqNo}+{SO_UDT_INVOICE_COPY.UDF_INVOICE_COPY_CODE}"". 6. Create a new group section using the formula. I placed this group between the standard invoice number and header sequence number groups. 7. Add conditional suppression formulas to the sections containing the commission text, '{SO_UDT_INVOICE_COPY.UDF_INVOICE_COPY_CODE} = ""1""'

@MoiraGoggin - I thought Paperless only had 1 copy?????

Probably...just didn't think about it other than another printer to try...

Just another note, my solution won't exactly play nicely with paperless, it forces crystal to see the invoice details a total of 4 times so if you send it to paperless, I imagine you will end up with the 4 pages in the pdf. It does at least solve the issue with the order of the paper.

So i got it to work with paperless. Also found another interesting piece of info after experimenting, when you click ""preview"" or when a document is sent to the pdf converter, the shadow text will never be populated. It is only populated when the report is processed to be printed to a printer set up under multi-part. I leverage this so that the record set up in multi-part had ""PRINT"" in the shadow text. I then changed my grouping formula so that if the shadow text equals ""PRINT"" then use the field value from the UDT else use """". I then suppressed the detail section if the UDT value is not ""1"" AND the shadow text is not ""PRINT"". This causes the report to only produce one page when previewed or sent to paperless and will create the 4 pages when sent to a multi-part printer. I then used '{SO_UDT_INVOICE_COPY.UDF_INVOICE_COPY_CODE} = ""1"" or (({SO_InvoiceWrk.PLEmail} = ""Y"" or {SO_InvoiceWrk.PLFax} = ""Y"" or {SO_InvoiceWrk.PLPDF} = ""Y"") and {@ShadowText} <> ""PRINT"")' to suppressed the commission section if the report was previewed or sent to paperless with the Paperless Office Output set to anything other than ""Print All"".