June 8, 2009 at 10:12 am
I’m just starting to venture into using stored procedure for my SSRS reporting.
I have a procedure that I modified and added a new parameter. I’m having trouble getting my SSRS to find the new parameter.
I’ve added it under the REPORT REPORT PARAMETERS but the procedure is not finding it and I’m getting the error ‘parameter not supplied.’
Is there a step I’m missing when a procedure it updated– or am I just doing something wrong in creating the Parameter
June 8, 2009 at 10:23 am
You are missing the fact that when stored procedure is modified SSRS cannot change your report data solution recreate said report with new version of stored procedure. I call this a known issue.
Kind regards,
Gift Peddie
June 9, 2009 at 5:49 am
This makes is sound like I need to rewrite my report each time I modify a stored procedure. Is this correct? Or maybe just when I add a new parameter to the stored procedure?
Sorry that is may sound so elementary -
June 9, 2009 at 7:09 am
When a stored procedure is ALTERED the SSRS designer can consumes it and return the new data but the controls will not show the changed data, now this is based on my experience.
Kind regards,
Gift Peddie
June 9, 2009 at 7:26 am
Thanks ! Anna
June 9, 2009 at 7:35 am
I am glad I could help.
🙂
Kind regards,
Gift Peddie
June 10, 2009 at 10:32 am
I always proceed as follows:
1) Change the result set of the SP.
2) Open the report in VS (report designer).
3) Choose the Data tab.
4) Refresh the field list.
5) There are your changes! 🙂
Best regards,
Dietmar Weickert.
June 10, 2009 at 2:37 pm
Dietmar Weickert (6/10/2009)
I always proceed as follows:1) Change the result set of the SP.
2) Open the report in VS (report designer).
3) Choose the Data tab.
4) Refresh the field list.
5) There are your changes! 🙂
I think I covered number five the SSRS designer brings back the data but your report preview returns old data that has been my experience, my reports are general more than fifthy pages by default. So you maybe right but I have not been able to get the controls to return the new data.
Kind regards,
Gift Peddie
June 12, 2009 at 6:19 am
I have always trained people that when using SSRS, if you make ANY change
to a stored proc to always then open rpt, go to data tab, select the dataset
that the proc is tied to, and click the green "Refresh". Else the report does
not detect changes consistently. This has always worked perfectly for me...
June 12, 2009 at 7:01 am
Thanks for the help all -I've got is working.
June 12, 2009 at 8:08 am
tiffanyjanetblack (6/12/2009)
I have always trained people that when using SSRS, if you make ANY changeto a stored proc to always then open rpt, go to data tab, select the dataset
that the proc is tied to, and click the green "Refresh". Else the report does
not detect changes consistently. This has always worked perfectly for me...
Try that for a 300 pages report and post back I know nothing short of recreating the exisiting report works for large dataset report.
Kind regards,
Gift Peddie
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply