I've a set of reports in a Visual Studio/SSRS project. We've recently moved the store procedures for the reports to a different server.
The shared data source has been pointed to the new server & db.
A particular report previews ok within Visual Studio, deploys with no errors but when running in Live environment it gives an error "Invalid object name 'CARE.dbo.contact_suppressions'. This is from some embedded sql in report which is fine when previewed & deployed though beforehand so when run in correct environment it works.
It seems to be looking at old server & db still after deployment. If I replace with old server db name in the embedded sql it works but shouldn't be going anywhere near there as the data source points to new server.
Any help would be appreciated. Thanks in advance.