MyDoggieJessie (3/17/2014)
Open the working report up in SSRS, go to properties and click the "Edit" button, this will allow you to download the RDL file.Go to the same report that's broken, go to the properties and click the "Update" button, and then upload the downloaded RDL file, and be sure to select overwrite option, click OK or Apply then do to the data source and verify that you have the correct one.
Execute the report in the Report Manager.
Does this resolve the issue?
Thanks again! I ran the steps you suggested but no luck. I also ran a text comparison on the RDL files and they are identical except for the server name.
I think the problem lies elsewhere - maybe there is a way the broken settings are cached so that even though the report settings are the same for both reports, the production server version is still somehow the old one?
Thanks again for any help.
- webrunner
-------------------
A SQL query walks into a bar and sees two tables. He walks up to them and asks, "Can I join you?"
Ref.: http://tkyte.blogspot.com/2009/02/sql-joke.html