Using StoredProcs with Parameters in SQL Reporting Service 2005

SQL Reporting Service provides an option for using stored procedure in the SQL Server instead of using a query in the report.This article takes you through step by step process of creating a dataset which used a stored procedure with parameters.