Report preview cannot find Data source folder

visual-studio-2012 sql-server-data-tools ssrs-2008-r2 ssdt-bi
user170442 picture user170442 · May 9, 2014 · Viewed 15.4k times · Source

When I try to preview report in Visual Studio 2012 Designer I am getting an error:

An error occurred during local report processing.
An unexpected error occurred in Report Processing.
An error occurred during local report processing.
Error in the application.

Could not find a part of the path '...\bin\Debug\Data Sources\SomeDatasource.rds'.

Couple remarks:

  1. There is a valid data source in project.
  2. When I build project it creates flat (no folders) structure of reports, datasets and datasources in bin\Debug folder
  3. Data Source folder (along with other folders) is defined for deployment only
  4. When I removed folders in deployment settings, it is still not working
  5. It might be related to installing the latest SSDT (11.1.40403.0) yesterday... however right after installing everything worked
  6. Everything worked in this configuration so far...

Answer

Terry picture Terry · Feb 4, 2015

1) open the report definition's xml by right click -> view code

2) browse to Report -> DataSources -> DataSourceReference

3) replace "/Data Sources/MyDS" with "MyDS"

This clearly should have been patched by now!

Related questions

Using SSIS BIDS with Visual Studio 2012 / 2013

I want to use SSIS /BIDS project in Visual Studio 2012. I have both Visual Studio 2010 and Visual Studio 2012 installed along with Microsoft SQL Server 2012. VS 2010 was installed first followed by MS SQL 2012 which got me BIDS integrated with VS 2010. However …

Read More
VS 2012 Database Project "unresolved reference to object" Error

I created SQL Server Database Project in VS 2012 & imported our database. When I build the project, I get a lot of "unresolved reference to object" Errors. These errors are only for a few views I have in my database. …

Read More
SSDT-BI SSIS in x64?

I run Visual Studio 2012 and I'm new to SSIS. I attempted to install SSDT-BI (June 2013 version) in order to research SSIS, but I was unable to complete the install with my default instance because the architectures don't match--my server is …

Read More