×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

print crystal invoice on multiple copies
3

print crystal invoice on multiple copies

print crystal invoice on multiple copies

(OP)
Macola ES 9.5.700

I want to give up printing multi-part forms on our dot matrix printer. The problem, we have a White copy, Blue copy and a Pink copy of the Pick Ticket. How do I now use the Crystal Report Pick Ticket form in Macola to print (3) copies of the Pick Ticket (to make up the 3-part form) and have a different Form Name print on each copy. I mean the first copy is "Customer Copy", the second copy would be "Internal copy" and the 3rd copy would be "Copy"????

I have the Form all made up just not sure how or where to add the "Copy Names".

RE: print crystal invoice on multiple copies

Do you own Flexibility?

I did something like this using Flexibility and Visual CUT (Millet Software) but it was pick tickets. We printed the pick tickets to file, which updates the status to 4 - pick ticket printed. On the post_save() event, Flexibility called Visual CUT, which then ran multiple copies of the picket ticket from multiple trays. This can even be done to different printers or can fire off an email pdf of the forms.

In theory, this is possible with straight Flexibility without using Visual CUT, but we found this cumbersome.

I'm 100% sure this can be done with invoices as well.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: print crystal invoice on multiple copies

(OP)
Thanks again dgillz,

We do have Flexibility, I will have to give that a try.

RE: print crystal invoice on multiple copies

Create your own table with the form names and add the table to the report. No need to join, form name field in your header and each single form should become multiple according to form name table record count.

RE: print crystal invoice on multiple copies

NEMacGuy,

That approach will produce multiple copies of the Pick Ticket (or conceivably, any form) however it won't be able to have different text at the top ("Customer Copy", "Shipping Copy") or draw from different printer trays to get a blue copy, pink copy, etc.

If you know a way to do this without 3rd party intervention I am all ears.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: print crystal invoice on multiple copies

Form name on top does work as print control table has 3 records with 2 fields the form name and number, I would just include the form name in the header. As far as different trays not sure why just buy presorted 3 color paper if you want to use colored paper and put it in one tray,switching trays slows a job down.

RE: print crystal invoice on multiple copies

2
I've used printmulti ( http://www.lvbprint.de/html/printmulti1.html ) to handle the printing of multiple copies to different trays containing different colored paper. It can even be used to print copies on two different printers if needed. It's free and it works great.

Basic steps - assuming the printer you are setting up is for invoices, and you are printing one copy to tray one and one to tray two;

1). Download and install the Print-Multi software from the web.
2). Create a new printer called ‘Invoices’. This printer should be a ‘local’ printer, printing to a local port, with output going to a temp file on the PC.
3). Go back into the newly created 'Invoices' printer and change print processer to ‘PrintMulti’ and RAW.
4). Install a new printer called ‘Invoices – Tray 1’ using the existing printer drivers and configure the printer to Tray 1.
5). Install a new printer called ‘Invoices – Tray 2’ using the existing printer drivers and configure the printer to Tray 2.
6). Edit the printmulti ini file to 're-direct' anything printed to the 'Invoices' printer to the "Invoices - Tray 1' and 'Invoices - Tray 2' printers.

How it works is you print your Macola invoice to 'Invoices' and behind the scenes printmulti hands it off to the two other printers. No changes are needed to your Macola forms or Crystal reports.

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

RE: print crystal invoice on multiple copies

I am in need of this. We need to print 3 copies of our crystal reports pick ticket since we are going to start using carbonless paper. I do have flex. Does anyone have any code for this? I tried printmulti but cannot get it to work. When I setup it up and print, nothing comes out. Can someone help?

RE: print crystal invoice on multiple copies

Call Peter at ERP Essentials. I am sure he can help you and this is definitely an easier route than Flexibility.

Software Training, Implementation, Programming and Support for Macola Progression, Macola ES, Synergy, and Crystal Reports. Check out our Macola tools: www.gainfocus.biz/exceladdin.html

RE: print crystal invoice on multiple copies

There are a few options for making this work, printmulti is just one, NEmacGuy's solution works as well. A lot depends on what you want to do with the different copies of the form you are trying to print. If you want the different copies to print on different trays, different colored paper, or even on different printers, then printmulti does this at the printer driver level so that no changes are required to your Crystal report at all. They key here though it that this occurs after the report has printed, so while the different copies can appear in different trays etc. the copies are identical in appearance.

Provided you have your printers setup correctly - using the general steps above, then the problem most likely lies in how your pintmulti.ini file is setup. Here's a sample that prints two copies of anything printed to the 'Invoices' printer. One copy is printed to the printer 'Invoice - Tray 2' and the other copy goes to printer 'Invoice - Tray 3'. Both of these printers use the same driver, and point to the same printer. The only difference between them is that they are configured to print on different trays;

CODE -->

[Common]
LogJobMask=4
LogJobFile=c:\windows\temp\jobs.csv

LogMask=27
LogFile=c:\windows\temp\debug.csv

[Invoices]
Active=1
PrintSelf=0
Action1=Print;PrintInvoiceTray2
Action2=Print;PrintInvoiceTray3

[PrintInvoiceTray2]
Active=1
Printer=Invoice - Tray 2

[PrintInvoiceTray3]
Active=1
Printer=Invoice - Tray 3 

If you want each copy to print from the same printer and tray, but have a different report tile for each copy, or different watermark etc. then I would go the direction that NEmacGuy indicated. That is, create a SQL table that you can link your Crystal report to that will force the report to generate multiple copies. I usually do this based on the order type, so that I can configure how many copies occur for each type of order (if needed). Here's some sample SQL code to create the table;

CODE -->

CREATE TABLE [dbo].[syfrmcpy_sql] (
	[ord_type] [nchar](1) NOT NULL,
	[copy] [nchar](10) NOT NULL,
	[copy_desc] [nchar](30)
) ON [PRIMARY]
GO 

You would then need to populate the table based on the number of copies you need e.g.
O, 1, Office Copy
O, 2, File Copy
O, 3, Shipping Copy

Peter Shirley
Macola Consultant, PA and surrounding states.
http://www.erpessentials.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close