Create a report based on a parameter using SQL Server reporting services

In this demo we will create a report based on a parameter using SQL Server Reporting services. In my previous post i had shown a demo as to how to create a basic report using SQL Server reporting services.

Step 1: Open SQL Server Report Builder
Step 2: Create a new Datasource as below
Step 3: Create 3 new datasets as below
Step 4 : Right click on Parameters option and click on “Add parameter”
Step 5: Create a new parameter as below
Step 6: Click on “Available Values” and set the options as depicted
Step 7: Click on “Advanced” option and set the options as depicted. Click OK.
Step 8: Click on Insert tab and select “Insert matrix”.
Step 9: Design the matrix as shown below
Step 10: Save the report. Now the report is ready to be run. Click on the run button in the home tab. The IE should show you the below. Select a country or multiple countries from the drop down and click on “View Report”.
I hope this demo would help you to create a report based on a parameter.