Post reply

Adding a filter to an SSRS Report

  • June 16, 2017 at 11:34 am

    #343252

    Hello, I have an existing SSRS report that has several fields in it and I would like to add a filter on Vendor Name to it.  It uses a stored procedure to return the desired results.  How can I add a filter on the returned results by providing a drop down list of vendors for the users to choose one or many from?  Is this possible in a filter?

    Thank you,
    David

  • June 16, 2017 at 3:18 pm

    #1947161

    oradbguru - Friday, June 16, 2017 11:34 AM

    Hello, I have an existing SSRS report that has several fields in it and I would like to add a filter on Vendor Name to it.  It uses a stored procedure to return the desired results.  How can I add a filter on the returned results by providing a drop down list of vendors for the users to choose one or many from?  Is this possible in a filter?

    Thank you,
    David

    Probably start here...?  It's not only possible, it's easy after you've done it once or twice. You basically create a second dataset to populate the parameter, and you're off to the races.
    There's a tradeoff between filtering your report in the stored procedure vs in the report using Filter properties. If you do it in the stored procedure, the records that don't match are not even returned to your report. If you filter (again) or filter in the report, all the data gets pulled into SSRS, and then those that don't match the filters are discarded there.

    Here's a good video on filtering in SSRS.

  • June 16, 2017 at 7:29 pm

    #1947167

    I now have a drop down that provides a list of vendor names to choose from.  It works fine if I specify only a single value.  As soon as I allow the user to choose multiple values, I get a datatype mismatch error.  Any ideas how to correct this?

  • June 16, 2017 at 10:50 pm

    #1947169

    You can't do a multi-select match with = in your filter.  Right-click your dataset, and go to Dataset Properties.  Under the Filters tab, you need to change the operator in your comparison from '=' to 'In', and then it will work.

  • June 17, 2017 at 5:33 am

    #1947171

    That worked!  Thank you very much my friend.

    David

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

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