SSRS Tutorial 36 - Use Stored Procedure with Single Value Parameter in SSRS Report

In this video of SSRS Tutorial, You will be learning

  1. Create Stored Procedure with Single Input Parameter
  2. Use Stored Procedure to create DataSet for Report
  3. Create Dataset for Parameter values
Create procedure dbo.sp_SalesTotal
@Region VARCHAR(100)
AS
BEGIN 
Select [SalePersonFName]
           ,[SalePersonLName]
           ,[ProductName]
           ,[ItemsSold]
           ,[SoldPrice]
           ,[SoldDate]
           ,[City]
           ,[State]
           ,[Country]
           ,[Region] 
           from dbo.TotalSale
           where Region=@Region
           END
 

Use Stored Procedure with Single Value Parameter in SSRS Report - SSRS Tutorial