Unknown error generating/adding reportsI checked the SSRS logs (in my case in C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\LogFiles) and found a message I have never seen before and was not anticipating:
The report parameter 'PARAM' is read-only and cannot be modified. ---> Microsoft.ReportingServices.Diagnostics.Utilities.ReadOnlyReportParameterException: The report parameter 'PARAM' is read-only and cannot be modified.Note that PARAM was substituted for the actual parameter name to protect the innocent. Bizarre, right? This happened on a column that was previously hidden from the user in the SSRS Report Manager. It would run just fine in SSDT (SQL Server Data Tools).
One thing I had noticed is that when I logged in, someone had applied updates to the SSRS server (or perhaps it was an automatic update). Aside from that communication slip-up between admins, I wonder if it's related? Microsoft released a bulletin a few months ago regarding this.
Here is the basic solution:
- Go into the SSRS Report Manager web interface.
- Find the report.
- Right click on the report and click Manage.
- Go to the Parameters tab.
- Uncheck the Hide and Prompt User checkboxes on the affected parameters.
- Apply the changes.
- Recheck the Hide parameter.
- Apply the changes.
- Test your report using it's parameterized URL to see if the problem is solved.
Simple!
No comments:
Post a Comment