Skip to main content
Solved

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


jeans16
Freshman II

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. 

Best answer by BenjaminCrisman

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.

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

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 631 replies
  • Answer
  • October 3, 2022

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.


lauraj46
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • October 6, 2022

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


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