Skip to main content
Answer

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

  • October 3, 2022
  • 2 replies
  • 545 views

jeans16
Jr Varsity II
Forum|alt.badge.img

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.

2 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • Acumatica Support Team
  • 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
  • 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