Post reply

One filter from multiple columns SSRS

  • April 28, 2020 at 11:50 am

    #3746954

    Hi, how can I create a single filter in SSRS with multiple columns? Below is an example of a table I am currently using.

    Capture

    I will like to have just a single filter with unique values of the above locations.

    Thank you

  • April 28, 2020 at 3:21 pm

    #3747032

    use OR?

  • April 28, 2020 at 3:24 pm

    #3747033

    Do you have an example expression?

    Thanks

  • April 28, 2020 at 3:39 pm

    #3747041

    [col1] = @Value OR [col2]=@Value

    ?

  • April 28, 2020 at 3:50 pm

    #3747044

    Thanks a lot 🙂

  • April 28, 2020 at 4:54 pm

    #3747070

    Hi again, I tried using an expression like below but getting "Failed to evaluate the FilterExpression of the DataSet" error

     

    Expression: =(Fields!Mon_AM_Loc.Value = Parameters!Location.Value) or (Fields!Mon_PM_Loc.Value = Parameters!Location.Value) or (Fields!Tue_AM_Loc.Value = Parameters!Location.Value) or (Fields!Tue_PM_Loc.Value = Parameters!Location.Value)

    Operator: =

    Value: =Parameters!Location.Value

     

    Any help will be greatly appreciated

    Thanks

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply