AUGForums.com

An Acumatica User Group

  • Free
    • Start Here
    • Rolodex
    • Podcast
    • Blog
    • Forums
  • Course
  • Consulting
  • Login
  • Register
Acumatica Forums

By using this website, you agree to our Terms of Use (click here)

  • Overview
  • Member List
  • All-Stars
  • Stats
  • Recent Posts
  • Help
Forums
AUG Forums
Acumatica Report De...
How to create a vis...
 
Notifications
Clear all

In order to allow me to focus on Consulting (click here) and Courses (click here), I continue to review all posts here in the Forums, but, in general, I'm only personally responding to posts that I mark as #AcumaticaTnT (click here). For Questions (click here), others may respond, or you can post over at Community.Acumatica.com (click here).
Sincerely,
Tim Rodman

Questions How to create a visible expression that uses Contains or StartsWith

Acumatica Report Designer
Last Post by Kurt Bauer 8 months ago
3 Posts
3 Users
3 Likes
463 Views
RSS
Andrea Grover, ECBA, CSSGB, CSM, CSPO
Posts: 1
 Andrea Grover, ECBA, CSSGB, CS...
Topic starter
June 7, 2022 1:02 pm
(@agrover)
Member
Joined: 12 months ago

I would like to be able to control the visibility of a field on the SO Invoice (SO643000) using a contains, like, or startswith filter.  I have not been able to get the syntax right.  'Like' using SQL syntax gave an unsupported error.  

=[ARInvoice.CustomerLocationID] StartsWith ('W/C?') will not validate and says Missing operator before the StartsWith operand.  Same if I use Contains.

I tried this and it basically ignores it:

=[ARInvoice.CustomerLocationID] = 'W/C?'

Can someone help with the correct syntax and which one works (contains or startswith)?

2 Replies
Dianne A
Posts: 23
 Dianne A
June 8, 2022 9:48 am
(@dianne-a)
Member
Joined: 3 years ago

Hi Andrea,

You can use the "InStr()" function to find strings within strings. It returns the position within the source string where the string to find exists. If it is not found, the function returns -1. The first position of the source string is 0.

Examples...

1) To look for "xyz" anywhere inside field [EPEmployee.AcctName], use the following - if the result is -1, it wasn't found; if the result is >=0, that's where it was found:

=InStr([EPEmployee.AcctName],'xyz')

2) To look for "xyz" only at the beginning of the field, use the following - if the result of the expression is False, it wasn't found at the beginning; if the result of the expression is True, it was found at the beginning: [use this for your Visible Expression]

=InStr([EPEmployee.AcctName],'xyz')=0 

Dianne

Reply
Kurt Bauer
Posts: 41
 Kurt Bauer
June 8, 2022 10:22 am
(@kurtybauer)
Member
Joined: 3 years ago

You could even use the Left() function in the visible expression.

=Left([DAC.FIELDNAME],1)='W' or Left([DAC.FIELDNAME],1)='C'

Kurt

Reply
Tim Rodman, Royce Lithgo and Dianne A reacted
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 11 Forums
  • 2,239 Topics
  • 9,872 Posts
  • 10 Online
  • 1,813 Members
Our newest member: Marion Hooley
Latest Post: Export Scenario - Export same row twice (Conditionnal)
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

Online Members

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © 2023 · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×