Step By Step SSRS in 11 Hours: Hour 4

Introduction

 

This article shows how to create a report that expects a parameter, in other words, a parameterized report. We pass CountryRowId as the parameter and we get all the states of that country.

 

Contents

• Hour 1: What is SSRS and determine whether it is installed
• Hour 2: Report using wizard
• Hour 3: First SSRS report
• Hour 4: Report with parameter
• Hour 5: Custom template
• Hour 6: Drill down report
• Hour 7: Sub report
• Hour 8: Report with style
• Hour 9: Report with chart
• Hour 10: Report deployment
• Hour 11: RDL file to ASP.Net

SSRS Report with Parameter

 

Step 1

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

Step 2

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

Step 3

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

Step 4

• Select Report and provide an appropriate report name.
  
  
  

Step 5

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

Step 6

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

Step 7

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

Step 8

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

Step 9

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

Step 10

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

Step 11

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

Step 12

• 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.
  
  
  

Step 13

• Map "StateName" in the second column.
  
  
  

Step 14

• Select and delete the third column.
  
  
  

Step 15

• Now the report design is ready.
  
  
  

Step 16

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

Step 17

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

Next >> Hour 5: Custom template