aaron.reese (5/23/2016)

---

Hi Guys,

We are about to move one of our operational servers to a new VM. As part of the checking I have discovered that I have in the region of 170 SSRS reports where at least one dataset query is hard coded to look at the specific server

SELECT

Something

FROM

[server].[database].[dbo].

So even if I change the connection parameters in the shared data connection, these reports will still try to link to the old server.

I know that the rdl is stored as an image, am I safe to update the data by converting it back to NVARCHAR, Replace the hard coded path with just the table schema and name and convert the result back to an image.

I would rather not have to download all the reports to BIDS, edit them and load them back up again.