How to print 3 copies of a form

Hi @mdubin66,

Check out this blog post written by @lauraj46 

https://www.linkedin.com/pulse/acumatica-tips-tricks-how-print-multiple-product-labels-laura-jaffe
 

In this example, she shows how to use the DateInfo table to print the same record a variable number of times.

Hi @mdubin66,

The method described in my blog that @Gabriel Michaud mentioned will only work if you need three identical copies of the same report.  It sounds like you need to print three different reports. You might be able to correct the pagination issue by creating a separate GroupHeader section as described in this article:

https://stackoverflow.com/questions/57860344/enable-multi-page-sub-report-in-acumatica-report-designer

Otherwise, automatically launching all three reports with a single click would probably require a customization as described in this blog by Sergey Marenich:

https://asiablog.acumatica.com/2017/03/launch-multiple-reports-with-one-exception.html

Hope that helps!

Laura

Laura - I think your technique can be used even if they have simple variations. Conditional formatting and the use of the VisibleExpr property can be used to show/hide fields based on the DateInfo table, so that some fields only show up on specific copies.

@mdubin66 can you describe the differences between the different copies?

Gabriel Michaud

First copy prints the unit price and “Office Copy” near the top.  Second copy does not print the unit price and has “Driver’s Copy” printed near the top.  The Third copy does not print the unit price and has “Picking List” printed near the top

@mdubin

In that case, it sounds like the idea that @Gabriel Michaud suggested should work!  After joining on the DateInfo table as explained in the blog, you can build a formula to adjust the text value or the visibility of the fields based on the difference between the DateInfo.Date column and ‘12/31/1969’.

For example:  =IIf(DateDiff(‘d’, ‘12/31/1969’, [DateInfo.Date])=1, ‘Office Copy’, IIf(DateDiff(‘d’, ‘12/31/1969’, [DateInfo.Date])=2, ‘Driver’s Copy’, ‘Picking List’)

You could build a similar formula for the visibility condition on the unit price.  

Laura

@lauraj46, 

I was able to get this to work.
I used a parent field of =’3’ on the join and added a new group at the top. 

The group data field is =CDec (DateDiff('d', CDate('12/31/1969'), [DateInfo.Date]))
Without the CDec & CDate, I was getting errors.

For the conditioning,   I also had to add the CDate
=iif ((DateDiff('d',CDate('12/31/1969'),[DateInfo.Date]))='1' ,'Office Copy', iif ((DateDiff('d',CDate('12/31/1969'),[DateInfo.Date]))='2','Drivers Copy','Picking List'))

Thank you.

Bill

@wfilipiak67 

Thanks for the update, and glad to hear you got it working!  

Here’s another way that avoids the need to use nested IIFs and DateDiff/CDate:

=SWITCH([DateInfo.DateInt],19700101,’Office Copy’, 19700102, ‘Drivers Copy’, 19700103, ‘Picking List’)

Very nice, @Gabriel Michaud !

I didn’t think about using the DateInt column this way but for a small fixed number that is perfect. 

@lauraj46 I somehow thought the table contained a simple integer counter, like the Unix Epoch. In this case the switch or IIF() would have looked even simpler, with 1, 2, 3 instead of a date. Thanks for all your help, great blog post and #AcumaticaTnt content!!!