Calculating Total of Column in Header Section

  • 13 September 2021
  • 2 replies

Userlevel 3
Badge +1

I am fairly new to Report Designer and I have a requirement where they want the total of a column in the header section, this should print only on the first page and values consideredshould be where page index = page count, how can I fulfill this?


Best answer by Naveen Boga 24 September 2021, 11:30

View original

2 replies

Userlevel 3
Badge +1

@Naveen B  thanks, I will try this approach.

Userlevel 7
Badge +17

Hi @TharidhiP if I understand correctly, you wanted to sum the grid column value and display it in the Header section.

If yes, I have created a sample example in Sales Order report. Please find the details below.

Ex: I’m displaying the sum of Grid Qty and showing in the Header section.

  • Create a variable, where you wanted to display this Sum of the Qty value (Header Section)
  • ValueExpr for the variable will be like Sum(Qty)
  • Create a new textbox field in the Header section.
  • Assign the variable to the newly created textbox.

Please find the screenshots for reference.



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