Solved

Using 'OR' in a visible expression on section in report writer

  • 4 October 2022
  • 2 replies
  • 301 views

Userlevel 2

Is there away to use ‘AND’ and ‘OR’ in a visible expression on a report writer section?  If so, what is the correct syntax as I have tried various parenthesis and cannot get it to work so any help would be appreciated. 

icon

Best answer by BenjaminCrisman 4 October 2022, 00:14

View original

2 replies

Userlevel 7
Badge +4

Hi @jeans16 ! In this case the visibility expression is a bit of an OR statement in itself.

Either it meets the visibility expression, or it doesn’t, but there isn’t a way to specify multiple visibility expressions for a single section.

The thing to do would probably be to duplicate the section with the visibility expression and create one for each instance needed, or use one expression which will bring in all the needed data and then use visibility expressions on the individual fields instead.

Userlevel 7
Badge +7

Hi @Jeans16,

Within the visibility expression that @BenjaminCrisman mentioned you can use also AND, OR and NOT.  The syntax is something like: =Condition1 OR Condition2

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