Saturday, June 12, 2004

HowTo: Create a SQL Server 2000 Reporting Services Report from a Stored Procedure 

Glen Gordon
The answer lies on the Data tab. When you go to that tab after the wizard has run, you'll see your EXEC statement. You want to change the query type from a text command (as is represented by the presence of the word EXEC) to a stored procedure. You do this by clicking on the button to switch to the Generic Query Designer view. Once there, you'll see a drop down on the right that says Command Type . It will say Text. Change it to StoredProcedure and remove the word EXEC and any hard-coded parameter values following the SP name. Now, if you click the Execute (!) button, you should see a window prompting you to enter parameter values. Try a few values in here to make sure it works.

Links to this post:


Comments: Post a Comment

This page is powered by Blogger. Isn't yours?