LIKE In RDLC Report

ElyesElyes Member Posts: 6
Hello,
I use a navision 2013
I would filter the databox with two chaine
The expression =Fields!ItemNo_ItemLedgerEntry.Value like "*paac" and "KIT-PA*"

Could you please help me

Answers

  • ElyesElyes Member Posts: 6
    vkbft18bidad.png
    of2f42du0vnd.png
  • ElyesElyes Member Posts: 6
    could you please help me?
    Thanks in advance
  • AluanAluan Member Posts: 102
    Hello Elyes,
    if you need a and condition you can add a second filter.

    First Filter with the value:
    *paac

    Second Filter with the value:
    KIT-PA*

    The Expression and Operator is for both filter the same.
  • ElyesElyes Member Posts: 6
    Hello Aluan,

    If a add the two filter the resultat is nullrw7mzr3hp8az.png

    when i add one filter the resultat is below only the PAAC is show
    5s4eggy1nfc1.png


    could you please help me?
  • Yannick1Yannick1 Member Posts: 5
    Use OR instead of AND
  • AluanAluan Member Posts: 102
    So,
    just for clarification, do you need all lines where the ItemLedgerEntry.Value end with "paac" AND start with "KIT-PA", or do you need the lines with ItemLedgerEntry.Value that end with "paac" OR start with "KIT-PA"?
  • ElyesElyes Member Posts: 6
    Hello aluan,
    Yes, Ineed the lines with ItemLedgerEntry.Value that end with "paac" OR start with "KIT-PA"
  • AluanAluan Member Posts: 102
    Then you need an or condition, as Yannick1 said. :)

    One way would be:
    Expression:
    =Fields!ItemNo_ItemLedgerEntry.Value Like "KIT-PA*" OR  =Fields!ItemNo_ItemLedgerEntry.Value Like "*paac"
    
    Type: Boolean
    Operator: =
    Value: TRUE

  • ElyesElyes Member Posts: 6
    Hello aluan,

    I have this error when i compile

    q9c06jfec3ho.png
  • AluanAluan Member Posts: 102
    Just type TRUE without anything else. If that doesn't work, take please a Screenshot.
Sign In or Register to comment.