Skip to main content
Solved

Process Order 'WhilePrint' on Detail Section in Report Designer


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.  

 

Best answer by lauraj46

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

View original
Did this topic help you find an answer to your question?

2 replies

lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 591 replies
  • Answer
  • March 27, 2024

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


BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 711 replies
  • September 13, 2024

@asullivanNAW Did you end up finding a solution for this? Laura’s explanation is pretty good, I would think you just had some of the details/sections mixed up, but also wanted to check to see if the issue was still ongoing


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings