A coworker posted a report definition (.rdl) file out onto the server, asking that I help her with adding some fields from some tables to several of the data sets for the report. I imported the report into Visual Studio (2010 SP1), but each of the data sets had a DataSource property which was not defined in my solution explorer. If I tried to edit the data set in the query designer I received an error message:
An Error occurred while connecting to the data source. Only the text-based query designer will be available.
The shared data source 'Kermit' does not exist or you do not have permissions. For more information, contact your report server administrator.
So I created a new shared data source with that name, pointing it to the appropriate Server and database, but I'm still getting that error.
If I change the data source to another previously defined data source, which works for other reports in my VS solution, I can open the data sets and run the queries just fine in the query designer. But when I try to preview this report I'm getting an error:
An error occurred during local report processing.
Error in the Application.
Could not find a part of the path '\\servername\gpshare\SRS_Projects\GPReports\GPReports\Maestro FP\Maestro FP\Maestro FP\bin\debug\data sources\MaestroFP.rds'
The \Data Sources\ folder does not exist on this path, but the rest of that path does exist. I cannot figure out where this path for the MaestroFP data source is stored and how to change this to point to a valid data source.