Monday, March 12, 2012

Passing a parameter to a stored procedure in Reporting Services 2000

I am new to SQL Server 2000 Reporting Services

I have a stored procedure that has a string parameter passed to it.I would like the user to select the value of the parameter from a list box which is populated by a table.

Any help would be appreciated.

Google may be a good start, or a book
http://www.15seconds.com/issue/041027.htm

SSRS 2005 is a bit different, but the idea is the same
You select the source "From Query" for "Available Values"
Select the query you like, with the Name, and Value column

No comments:

Post a Comment