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 belowStep 3: Create 3 new datasets as belowStep 4 : Right click on Parameters option and click on “Add parameter”Step 5: Create a new parameter as belowStep 6: Click on “Available Values” and set the options as depictedStep 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 belowStep 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.