CODEWITHSUNDEEP
reporting-services
UpwardD
UpwardD

Reputation: 767

Output Parameters in SSRS

How do I create a report with a Stored Procedure which has an output parameter? The report can be developed but returning the output parameter is what I am trying to figure out.

Upvotes: 3

Views: 2251

Answers (1)

Pred
Pred

Reputation: 9042

SSRS does not support output parameters by default.

If your SP does not return any resultset, you can get the output parameters by wrapping the SP call in a regular query text:

DECLARE @x

EXEC dbo.YourSP @outX = @x OUTPUT

SELECT @x

Upvotes: 3

Related Questions