locked
SSRS Filters Multiple values RRS feed

  • Question

  • User2043906112 posted

    I have parameter called CodeValue which is optional or passed as comma delimited string (multiplevalue) from application to SSRS Report.

    I have configured SSRS filter expression like

    =ISNOTHING(Parameters!CodeValue.Value) or (Fields!Code.Value = Parameters!CodeValueValue) and Type as "Boolean" operator as "=" and Value as "True"

    When I pass multiple value (delimited string) in frontend for Parameter Codevalue it is not returning any records.

    How will I do something like seen below

    =ISNOTHING(Parameters!ICD_1.Value) or (Fields!ICD_1.Value In Parameters!ICD_1.Value)

    Friday, April 10, 2015 9:36 AM

Answers

  • User1711366110 posted


    I solved by means of below expression
    =Iif(IsNothing(Parameters!CodeValue.Value)=True,True,Iif(InStr(Parameters!CodeValue.Value,IIF(ISNOTHING(Fields!Code.Value)=true,"ab",Fields!Code.Value))>0,true,false))

       That's fine.. If you know more about expression for different tasks with lots of example in SSRS, then refer the following links :

    https://msdn.microsoft.com/en-us/library/ms157328.aspx

    --
    with regards,
    Edwin

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 13, 2015 2:05 AM

All replies

  • User2043906112 posted

    I solved by means of below expression

    =Iif(IsNothing(Parameters!CodeValue.Value)=True,True,Iif(InStr(Parameters!CodeValue.Value,IIF(ISNOTHING(Fields!Code.Value)=true,"ab",Fields!Code.Value))>0,true,false))

    Friday, April 10, 2015 11:32 AM
  • User1711366110 posted


    I solved by means of below expression
    =Iif(IsNothing(Parameters!CodeValue.Value)=True,True,Iif(InStr(Parameters!CodeValue.Value,IIF(ISNOTHING(Fields!Code.Value)=true,"ab",Fields!Code.Value))>0,true,false))

       That's fine.. If you know more about expression for different tasks with lots of example in SSRS, then refer the following links :

    https://msdn.microsoft.com/en-us/library/ms157328.aspx

    --
    with regards,
    Edwin

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, April 13, 2015 2:05 AM