In an existing SSRS 2008 report, there is a dataset setup in a text format that looks like the following:
exec Sch..procSTEP2Reportxxryz @searchField, @searchFieldValue, @userCalendarId, @stepReviewDateFilter
This dataset is using a shared datasource called TBB. However the stored procedure actually exists another shared datasource called Sch.
What to do is to rename the existing stored proceudre from procSTEP2Reportxxryz to procSTEP2Report to meet my company's naming standards.
The problem that occurs is the SSRS report must not recognize the new stored procedure. It keeps showing me the parameter values that are listed above
and seems to want a blank or null value for each of the 4 parameters.
When I run I run the new stored procedure in SSIS manager and supply the 4 parameter values, it runs fine. However when I
exec Sch..procSTEP2Report @searchField, @searchFieldValue, @userCalendarId, @stepReviewDateFilter in the ssrs 2008 report, it thinks the parameter values are misssing.
In the dataset, I have tried to the following with no success:
- Change the shared datasource,
2, Delete the parameters and readd them.
However nothing seems to work.
Thus can suggest what I should do to solve this problem?