Use Stored Procedure Output Parameters in SSRS
August 5th, 2008 in Blog, Reporting Services, SQL ServerIt’s commonly known that there are a few frustrations when using stored procedures as the source for SSRS 2005 datasets, the inability to cope with temporary tables is always a key one, another is not being able to get at output parameters or return values. This post explains the easiest way to get at the output parameters and return value. Lets assume you are using the following stored proc: IF OBJECT_ID('myProc') IS NOT NULL DROP…
» Read more