Something weird is happening to me - Never happened before on 100's of reports using Shared Data Sources.
I have a Shared data source defined and when I try to preview a new report, I get a message saying that "The data source 'ProjectList' cannot be found"
When I created the dataset, I pointed it to the shared data source. I can preview the data when I run my query from query designer, so it's obviously seeing my shared data source.
If I use an embedded data source, the report renders just fine.
I'm using SSRS 2008R2 BIDS to develop the report - the data source is hosted from a SQL Server 2008R1 database.
Anyone ever seens this? How'd you get out of it?
View Complete Post