We added a new parameter to a stored procedure that runs behind a custom InfoMaker report. I can execute the procedure just fine in SSMS and I have added the parameter (in the correct order) to the edit report screen:
Now I keep getting this error when I try to run the report in the client:
Does anyone have any experience with this?
** We are self-hosted **
Ashley Elliott
Database Administrator
St. Louis Symphony Orchestra
314-286-4198
ashleye@slso.org
It has thankfully been years since I've fiddled with Widowmaker, but have you updated the report in Infomaker to include the new parameters?
How do I do that?
I tried clicking here:
and selecting the updated stored procedure and saving.
Ashley
That should be it.
I think you do need to manually update the parameters? I can't remember all the headaches now, but a rule of thumb was any time something changed with a stored procedure I would generally just delete all the parameters/return values and build them again from scratch.
SOLVED: I created a test version of the InfoMaker template and what I had yet to do was tell the report to pull that template instead of the original.