Example Query Configuration — SSRS Report Development
Dealing with Procedures When using Stored Procedures in SSRS: In SSRS, map the dataset query type to "Stored Procedure", pick GetSalesByRegion, and SSRS will automatically detect @RegionName as a report parameter.