Skip to main content
Answer

Report Designer Filter on first character of a text field

  • February 2, 2024
  • 6 replies
  • 233 views
L
Captain II
Forum|alt.badge.img+5

Hello,

I have a parameter.

I want to select location records when the 1st character of the location is equal to the parameter value.

I don’t get any errors, but I do not select any records when I know I should.

Any thoughts?

Default value of ROW below is “A”.

I know I have locations that start with “A” and I report these when the filter is off.

 

 

Best answer by ltussing03

Laura thanks for your help with this.  It is working now.  I needed the formula on the left side, under Data Field.  When I had tried to put it there directly it wouldn’t stick.  However, when I clicked the “Data Field Formula” button, it allowed me to enter the formula and it stayed.

Thanks again for taking the time to help with this!

If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    robk20

    6 replies

    lauraj46
    Captain II
    Forum|alt.badge.img+8
    • lauraj46
    • Captain II
    • February 3, 2024

    Hi @ltussing03 ,

    Try joining INLocation and filtering on the left character of LocationCD rather than LocationID.  

    Hope this helps!

    Laura 

     

     

     

    Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Samvel Petrosov
    Chris Hackett
    L
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • February 3, 2024

    Laura,

    Thank you so much for replying!  You are absolutely right about using the “CD” inventory ID!

    Unfortunately, I am still not getting any results when the filter is enabled. 

    I printed my “Left” formula on the report, and dropped the filter, and it is printing the expected value of “A”.  But I still get no results with the filter enabled.

     

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    lauraj46
    Captain II
    Forum|alt.badge.img+8
    • lauraj46
    • Captain II
    • February 3, 2024

    Hi @ltussing03 ,

    Are you possibly missing the = sign in front of your formula?

    Laura 

    Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    L
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • February 3, 2024

    Laura,

    Thanks for taking the time to reply on a Friday night!!

    I’ve tried that as well with no results.

     

     

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    lauraj46
    Captain II
    Forum|alt.badge.img+8
    • lauraj46
    • Captain II
    • February 3, 2024

    Hi @ltussing03 ,

    I will try to replicate this when I have a minute, probably on Monday :)

    Laura 

    Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    Chris Hackett
    L
    Captain II
    Forum|alt.badge.img+5
    • ltussing03
    • Author
    • Captain II
    • Answer
    • February 3, 2024

    Laura thanks for your help with this.  It is working now.  I needed the formula on the left side, under Data Field.  When I had tried to put it there directly it wouldn’t stick.  However, when I clicked the “Data Field Formula” button, it allowed me to enter the formula and it stayed.

    Thanks again for taking the time to help with this!

    If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
    lauraj46
    Chris Hackett
    Y
    Terms & ConditionsCookie settingsAccessibility statement
    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