Solved

How can we create variables in Report Designer?

  • 20 October 2023
  • 1 reply
  • 321 views

Userlevel 6
Badge +3

Hello Comminuty,

I would like to know how can we create variables in Acumatica Report Designer? Specially if a new datetime field is added on the screen and the user wanted to see the full format as 20 October 2023.
 

 

icon

Best answer by craig2 20 October 2023, 16:11

View original

1 reply

Userlevel 4
Badge +1

Hi @Harshita ,

Yes, you can create additional Variables in a report, it’s very powerful functionality.  They reside in the different data levels, so you first have to select a Detail or Group area, then open up the Variables screen:

 

From here, you can add Variable formulas, reset conditions, and the like.  Be aware that the data level (Detail/Group) you put a variable matters, I often have to play around to get it to work properly.  You can even pass a Variable from a Subreport, but that gets really tricky.

 

Good luck!

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