OK, I can see the issue, but I don't know how to fix it. My reporting server has several application environments. In this case, I have my BIDS project set up with a Data Source deployment directory of {App Name}/Data Sources and I have my report deployment directory set to {App Name}/Reports.
I can design and preview my report with no issue, but when I go to deploy, it says the report definition is invalid.
I pulled the report open in Report Builder and it complained the data source was not valid, so I reselected the shared Data Source which did deploy. It can then be run in Report Builder. When I switch back to Visual Studio, I now get the same invalid error and now when I preview it, I get the error mentioned in my subject. More specifically: Could not find a part of the path 'C:\{Source Code Directory}\bin\Debug\{App Name}\DataSource1.rds.
The root of the issue seems to be that the Visual studio project dumps the report and the Data Source into the same folder, but the environment is separate folders. And either way I change it seems to not work.
Has anyone had any success with an environment similar to this?
Thanks.
Submit an article or tip