I downloaded the Reporting Service Samples for SQL Server 2008 R2 to a 64-bit Windows 7 machine with Visual Studio 2008. When I tried to open the solution file at:
C:\Program Files\Microsoft SQL Server\100\Samples\Reporting Services\Report Samples\AdventureWorks 2008 R2 Offline Sample Reports
I get an error:
One or more projects in the solution could not be loaded for the following reason...
Reason:
I finally figured out it is due to the inconsistency between the project path in the solution file and the actually folder name. For some strange reason, the installation process created three folders for the offline sample:
ChartSamples 2008 R2
GaugeSamples 2008 R2
TextSamples 2008 R2
But the relative path in the solution file in XML refers to as below:
ChartSamplesRS2008R2
GaugeSamplesRS2008R2
TextSamplesRS2008R2
Solution:
The solution obviously is simply to rename the folders as specified in the solution file. In addition, for another strange reason, the rdl files for the chart samples are not loaded. So I have to manually add them into the project (total 11 files).
The solution obviously is simply to rename the folders as specified in the solution file. In addition, for another strange reason, the rdl files for the chart samples are not loaded. So I have to manually add them into the project (total 11 files).
P. S. SQL Server 2008 Samples do not have such a problem. It is only a problem for R2.
