Hour 4: Report with Parameters

Introduction

SSRS Report with Parameter

• In order to create a shared dataset, right-click on "Shared Datasets" and click on "Add New Dataset".
  
  
  

• Provide an appropriate name of dataset.
• Select the data source.
• Select the "Stored Procedure" radio button and provide the Stored Procedure name.
  
  
  

• Now let's add the report. Right-click on "Reports", select "Add" and click on "New Item…".
  
  
  

• Select Report and provide an appropriate report name.
  
  
  

• To add a parameter, right-click on "Parameters" in Report Data and click on "Add Parameter…".
  
  
  

• Provide a parameter name and change its visibility to visible.
  
  
  

• Add a data source in the report data.
• Right-click on "Data Sources" and click on "Add Data Source…".
  
  
  

• Provide a data source name and select a data source reference.
  
  
  

• Add the data set to the report data.
• Right-click on "Datasets" and click on "Add Dataset…".
  
  
  

• Provide the data set name and select shared data set.
  
  
  

• Open the report file.
• Right-click on the design surface, select "Insert" and click on "Table".
  
  
  

• It will add a table to the report design surface.
• Set "State Row ID" and "State Name" in two different column headers.
• Map "StateRowID" in the first column.
  
  
  

• Map "StateName" in the second column.
  
  
  

• Select and delete the third column.
  
  
  

• Now the report design is ready.
  
  
  

• Click on preview to check the report.
• Pass a parameter value.
  
  
  

• You can see the list of states for the country you passed in the parameter.