Solved

Report Writer VisibleExpr for displaying text field

  • 11 April 2023
  • 2 replies
  • 91 views

Userlevel 5
Badge

Hi all,

 

I think I’m screwing up my VisibleExpr -- If an InventoryID contains ‘SIM’, I want it to display a text field, but I think I messed up the syntax as I’m getting an error.

 

=IIf( InStr( [AMProdItem.InventoryID], 'SIM' )<0, False )

 

Is there a better way to define ‘contains’ in the expression?

icon

Best answer by lauraj46 11 April 2023, 23:22

View original

2 replies

Userlevel 5
Badge

Hi @swartzfeger ,

In your expression you are missing the False argument.  I think it should be something like this:

=IIf( InStr( [AMProdItem.InventoryID], 'SIM' )<0, False, True )

Hope this helps!

Laura

Sorry for the late reply Laura but your expression was perfect. I definitely need to read up on expressions so I can learn to parse these better and recognize errors more quickly!

Userlevel 7
Badge +8

Hi @swartzfeger ,

In your expression you are missing the False argument.  I think it should be something like this:

=IIf( InStr( [AMProdItem.InventoryID], 'SIM' )<0, False, True )

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