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
Thank you. Forgot that I had set that in that report. Was odd that only one SSRS report was not working.
Dean - I've run into this with SSRS reports that specifically have date parameters that are left visible. That might explain why it was just that one report- other parameters seem to be less sensitive, but dates will break an SSRS report every time.