Macola ES 9.5.5 - ICR

[ultrav]

Going over to Macola ES and I am getting the forms ready. I am trying to get 3 copies of the pick ticket to print without my users having to select 3 copies when printing. I tried in Crystal under page setup - printer - properties - it says 3 copies but only prints 1. I also tried to add the report as 2 other subreports but I don't get all the detail I need on the copy pages (item comments, feature options, etc.). Any ideas?

Celeste

 

[dgillz]

Are you testing this on the same workstation where you changed the crystal report?

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[NEmacGuy]

This one is probably a little on the crazy side. But I normally use the database. I add a table, lets say zzz_pickfrmctl, and add three records. Many time I add the form name, such as Accounting Copy, Customer Copy, SomeOther Copy. I would then add the table into the crystal report, but not link it. Add the form name onto your report, and end up with three copies, with different form names. Having explained this, I know a few times things got a little more complicated. I know in one case I had to add "Ord_Type" and linked to the "Ord_Type" field as the crystal report would not allow me to have an unlinked table, which I do regularly. Perhaps also had to play with the report grouping to group on a field from the zzz_pickfrmctl. I am also using this with a link for customers that get emailed invoices. Only print 1 copy from crystal with a watermark "EMAILED" and form name "Accounting Copy", where invoices to mail print two copies.

 

[crystalreporting]

Yep - agree with NEmacGuy. Create a SQL table with a field you can link to. I usually create a table with two fields; ord_type and copy. This allows you to link from the order header or line based on order type - if you need 3 copies of the invoice, then you would create 3 separate records in the table;

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[syfrmcpy_sql]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[syfrmcpy_sql]
GO
CREATE TABLE [dbo].[syfrmcpy_sql] (
[ord_type] [nchar](1) NOT NULL,
[copy] [nchar](10) NOT NULL
) ON [PRIMARY]
GO

For three copies, populate the table like this;

ord_type copy
O 1
O 2
O 3

By linking to this table and adding a field from the new table to your report, you automatically return 3 times as many records. You can then group on the 'copy' field. This also allows you to change the appearance of each copy using watermarks, conditional formatting etc.

To have this work with the canned invoice (for example) simply add the new table to the report and include it in the grouping formula 'GroupByInvNoOrOrderNo';

if {@ExactPrintBy} = "O" then
    {OEORDHDR_SQL.ord_no} + " - Copy " + {syfrmcpy_sql.copy}
else
    {OEORDHDR_SQL.inv_no} + " - Copy " + {syfrmcpy_sql.copy}

Some of the 'canned' reports don't like it when you add new tables to them, but I've added the multi-copy logic to the canned invoice, acknowledgement, pro-forma and packing list without any problems.



Peter Shirley
Macola Consultant, PA and surrounding states.

http://www.erpessentials.com