Hi all,
I'm trying to add a parameter of season_no to an Infomaker report that previously had a hard-coded value for a former season and am getting an error when I attempt to generate through Tessitura. The error is "Datawindow Retrieval Error - Procedure expects parameter @season_no which was not supplied."
I've altered the SP and that is working - when executed through SSMS it requests a value for the season_no parameter and generates accordingly.
I've added a retrieval argument in the Infomaker template. When I open the report through Infomaker, the parameter also works correctly.
I added a parameter row in Report Set-Up for this particular report and specified Data Type, Table, Display Column (description) and Data Column (id).
The parameter is functioning as I'd like it to in the Report window in Tess. That is, the new parameter is there and the values are all accurate. But it seems like it's not passing it correctly from Tess to Infomaker?
So far all of these changes are in our Test environment and I've confirmed that's the case with each application. I closed and reopened both Infomaker and Tess, but no luck.
This is my first time adding a parameter to an Infomaker report, but I basically mimicked another one that is working.
Am I missing a step? Happy to provide more detail.
THANK YOU!
Frannie
Hi Frannie,
Have you tried adding the stored procedure to the Infomaker report again (Right click on the column specification, select stored procedure, click on procedure, find the one you're after, click OK etc.)?
Cheers,
Patrick.
Hi Patrick -
Thank you - I was so hopeful this was going to be it! I had not reselected the SP since altering it, so I did, and reset-up the retrieval argument, but am getting the same error.. grrr...
Anyone else?
Thank you!
I figure it out! When I was in Infomaker, although I was connecting to our Test db, when I was choosing my Report Library, I was selecting Live (on autopilot)... The fourth time I logged in, I finally realized this--
Chose the Test Report Library, opened report, reselected SP, and it worked.
Happy it was me and not Infomaker...