SSRS: Passing different parameter values to stored procedure for two Data Sets

Question

I have two tables in my Report. Both use two separate Data Sets, which get data from the same Stored Procedure. Now, I want the data sets to get different data based on different parameter values. Is there a way to achieve that? I am using SQL Server 2008-R2. Thanks in advance...

Daryl Wenman-Bateson · Accepted Answer · 2012-12-11 12:30:52Z

2

Within the Report Data screen (Ctrl+Alt+D), you can tie both datasets up to different parameters.

Add your parameters
Open up the Datasets properties
Go to the parameters section
Add the required parameter and give it a name the same as your Stored Proc parameter e.g. @EmployeeId

providing the query is marked as type "Stored Procedure" (in query section), this will pass the parameter over on selection. Repeat the process for the other dataset

answered Dec 11, 2012 at 12:30

Daryl Wenman-Bateson

3,9541 gold badge23 silver badges39 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

SSRS: Passing different parameter values to stored procedure for two Data Sets

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related