Recently I have been making some changes to our SQL Server Reporting Services machines. I am finding that many of my changes are not taking effect on the server.
The deployment goes ok. The reports show that they have been updated, but some things seem to not transfer.
For example, I changed the data source on some reports and redeployed them, but this new setting did not make it to the server. If I delete the report and THEN deploy it, it works fine.
Another issue was with some reports where I was trying to change some of the parameters to take a default null value. I made the changes in my reports and deployed. The reports now ALLOWED a null value, but they were not setup for the null to be the default value.
Once again deleting the report and deploying fixed the problem, but this is stupid.
Has anyone else had this problem, or have know of the reason why it doesn’t work right?
I got a response from someone on this. Apprently Microsoft felt that certain changers like changing report parameter details, could cause existing report parameter settings to be overwritten (well duh) and you as a developer probably didn’t realize what you were doing (hmmm yes I did) and so they don’t update everyone on the server when you redeploy a report.
Brilliant! No warning, no message, just some things are not updated.