Feb 1, 2016

Filter Parameter in SSRS

In this article you will lean what is Filter Parameter in SSRS and how it works with an example.

Filter Parameter(s) are used to filter the result on the report once the data is fetched from the database. It is alternate to Query Parameter to filter the result, but not efficient as it filters the data on the front end which lead to fetching all the data from the database and increasing the network flow

Let's create a report to see how Filter Parameter works.

Step 1: Create a simple Tabular Report
  • First Create a simple Tabular Report using above link. Once report is created we would apply Filter Parameter on the report.

Step 2: Add and configure Parameter
  • On Report Data Tab, Click Parameters and Add Parameters

 Filter Parameter-01

  • Configure Report Parameter properties as below and click OK

Report_Parameter

  • This will add GroupName Parameter under Parameters like below.

Parameter Added

Step 3:  Add Filter Parameter
  • In Report Data Tab right click DataSet1 under Datasets and then click Dataset Properties

ds_prop

  • Select Filter Tab and Add Filter. Click fx and select Parameter GroupName as value in the pop up window.

Configure Filter


We are done with adding Filter Parameter to the Report.

Now let's build the Solution and run the report. The Parameter GroupName that we created in step 2 is appearing in the report to filter the result set.

Enter Manufacturing in the text-box and click View Report

Report Output

Look at the output, the report data is filtered with Group Name as Manufacturing

    Choose :
  • OR
  • To comment
No comments:
Write Comments