Setting report dataset using stored procedures

[nimarii]

Hi,

This is my first time using REporting Services, and I'm also a newbie with SQL Server 2000.

Is it possible to set the dataset of a report using a stored procedure?

I have a webform that provides a dropdown list of possible order numbers to generate a report on. When the "view report" button is clicked, i would like to kick off a stored procedure using the selected order# as an input parameter, and use the resulting table dataset as the datasource of the report.

thanks!

 

[goodspeed7]

Yes that is possible,

First you need to set up a parameter in your report and set it up to list values from the stored procedure.

Then you need to go to the data tab, click on the elipse next to the data source name and click the filter tab. From there you set your filter to equal your parameter.

Then it will filter out all the number but the one you picked.