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