Skip to main content
Answer

How to use String Contains in Report Designer

  • June 8, 2023
  • 9 replies
  • 1012 views
S
Freshman I

Hi everyone, How to use string contains function in report designer, If I saved string list in the particular field means How can check particular string is there or not 

My field Name TypeofChange

Field Value  = Design; Sub-con's Proposal; 

My question is ‘Sub-con's Proposal’ string is available or not in the particular string field

 

 

Best answer by darylbowman

The single quotation used as an apostrophe is closing the string too early.

Try this:

=InStr([ChangeRequest.TypeOfChange],’Sub-con\’s Proposal’)

    9 replies

    ThasinduRanasinghe61
    Jr Varsity I
    Forum|alt.badge.img

    @sathish80 you can use InStr( str, findStr ) function.

     In Expression Editor box >Functions > Text

    S
    Chris Hackett
    S
    Freshman I
    • sathish80
    • Author
    • Freshman I
    • June 8, 2023

    @ThasinduRanasinghe61 thank you your reponse, I already used this but i cannot use string with ‘single quotation’ InStr([ChangeRequest.TypeOfChange],’SubCon’sProposal’)

    can you help me to solve this issue

    darylbowman
    Captain II
    Forum|alt.badge.img+15

    'SubCon’sProposal' is not the same as ‘Sub-con's Proposal’. Which one are you trying to find?

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    S
    Freshman I
    • sathish80
    • Author
    • Freshman I
    • June 8, 2023

    I am trying ti find this one  ‘Sub-con's Proposal’.

     

    darylbowman
    Captain II
    Forum|alt.badge.img+15

    Then your formula should read:

    InStr([ChangeRequest.TypeOfChange],’Sub-con’s Proposal’)

    Can you confirm that it does?

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    S
    Freshman I
    • sathish80
    • Author
    • Freshman I
    • June 8, 2023

    Thank you for your response 

    I used following this got error missing operator before the operand

     

     

    darylbowman
    Captain II
    Forum|alt.badge.img+15

    The single quotation used as an apostrophe is closing the string too early.

    Try this:

    =InStr([ChangeRequest.TypeOfChange],’Sub-con\’s Proposal’)

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    Chris Hackett
    S
    Freshman I
    • sathish80
    • Author
    • Freshman I
    • June 8, 2023

    @darylbowman Thank you so mush its working fine now

     

    darylbowman
    Chris Hackett
    darylbowman
    Captain II
    Forum|alt.badge.img+15

    Sure thing

    Daryl⚡Freelance Acumatica Developer (MVPx2🏆) for hire ⏩ linkedin.com/in/darylbowman
    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