Question

Process Order 'WhilePrint' on Detail Section in Report Designer

  • 20 March 2024
  • 1 reply
  • 30 views

I have been asked to produce a form that prints the total of a collection variable on page 1 of the form, page 1 of the form will print detail lines 1 - 10, then text boxes for collection variable total, form verbiage and signature boxes. Page 2, 3 … will print detail lines of the SOShipLine with the collection variable calculated with each line.  I thought this could be accomplished with the WhileRead on the collection variable and WhilePrint on the detail sections.   I have placed a visibility expression on the detail section to print the required text boxes at bottom of page one, but this section prints for every detail line.  It appears the visibility expression isn’t working.  I haven’t been successful finding online documentation that guides the usage of ProcessOrder WhilePrint for detail sections.  

 


1 reply

Userlevel 7
Badge +7

Hi @asullivanNAW ,

It seems like you may have the WhileRead and WhilePrint sections reversed.  My understanding is that WhileRead is calculated on the first pass and WhilePrint on the second pass.  You would perform the variable calcuations in the detail section that is WhileRead. 

Rather than printing the totals in the details section, you might consider using a page footer for this and setting the visibility for the page footer section to print only on page one.  The formula builder includes a Global Variable to access the PageIndex. 

Your page footer should have a ProcessOrder of WhilePrint or Always.

Hope this helps!

Laura

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved