Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I refresh a stored procedure to show new param?

Status
Not open for further replies.

dianemarie

Instructor
Jul 11, 2001
583
0
0
US
Hello, I have a report using a stored procedure. I have since updated the stored procedure to include a new parameter. I can't get SSRS to recognize the parameter though. Tried refreshing the dataset, saving the report, getting out and going back in. I can't get it to see the parameter. Any help would be appreciated. Thank you.
 
Also tried executing the dataset in the query window. Also clicked the refresh button in the dataset query window. Tried saving again. Should this be this difficult? No. :)
 
OK, it is simple. Once I um...got my sproc names straight. (Changes were made to a copy of the sproc in case I screwed it up, and the report was still pointing to the original.) All is well.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top