Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2008-04-03 : 10:42:02
|
| Hi I am sql server 2005.how to create rdl using stored procedure which uses parameter Thank you. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-03 : 10:56:05
|
| Create your stored procedure with parameter in your db. Goto Business Intelligence studio add a new project with a blank rdl. Go to data tab. Create a new dataset, give appropriate name and select stored procedure for command property. save it and click run icon (!) on top menu of datatab. It will automatically ask for parameter values as per your SP definition. Provide your values and it executes sp & populates the grid with sp results. click refresh button on top toolbar and automatically it updates dataset with resultset of your SP.Now go to layout tab and drag & drop tables,matrix,... from toolbox according to your need. You can now drag & down fields from your dataset onto container to show report data. |
 |
|
|
|
|
|
how to create rdl using stored procedure which use