I am working on my second custom report, and I am running into an error when I try to run the report on our Test database:
"Exception of type 'System.Web.HttpUnhandledException' was thrown.The given key was not present in the dictionary."
After a bit of searching online I thought it was related to either parameters not being named or passed correctly, or that the rdl.data file needed to be deleted. After trying those I still cannot get the report to run. It works fine in preview through BIDS.
When I try to run the report through Tessitura it shows just the first parameter, "begin dt" but doesn't show any of the others.
If anyone has any ideas as to what could cause this I would really appreciate it.
Andrew,
I believe what you're seeing is a known issue that surfaces with custom SSRS reports after an upgrade to V12.5.1 of Tessitura.
Any reports created in prior versions of Tessitura and then upgraded will now require parameters to be hidden. You will need to go into SSRS Report Manager, navigate to each of your custom reports, and check the Hide box for each parameter.
Dale
Dale,
That solved the problem, thank you! I was thinking I would leave them visible during the testing phase so I hadn't changed it yet.
-Andrew Gerritsen