1

I've installed a new instance of Visual Studio 2008 BIDS on my laptop (from here) and I am trying to open an existing 2008 reports solution. It opens, however all the shared datasets appear to be missing and when I try to build I get the following error:

[rsInvalidReportDefinition] The report definition is not valid. 
 Details: The report definition has an invalid target namespace
          'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' 
          which cannot be upgraded.

I've tried installing the Microsoft Report Viewer 2010 Redistributable Package referred to in this question, but nothing changed.
I've also tried just updating the xml to 2008 as the reverse of what is described here with no success.

My best guess is that maybe my laptop is missing some kind of file? But Windows Updates are up to date.

The reports solution opens fine on another PC with Visual Studio 2008 installed.

Community
  • 1
  • 1
JumpingJezza
  • 5,498
  • 11
  • 67
  • 106

1 Answers1

0

This SO answer says that SQL Server 2008 does not support shared datasets, only 2008 R2.

So I installed SQL Server 2008 R2 Express and got a different error:

The dataset, MyDataset, is a shared dataset. 
SQL Server 2008 Reporting Services does not support shared data sets.

Which according to this msdn forum post describes that the Express version does not support shared datasets.

Shared Dataset is tied with “Report Part Gallery” in terms of SKU restrictions. As documented here, Report Part Gallery is only available in Standard Edition and above.

Upgrading to the Standard version of SQL Server 2008 R2 fixed the problem.
(Maintenance > Edition Upgrade in the setup)

I also had to change my project properties > TargetServerVersion from SQL Server 2008 back to SQL Server 2008 R2, which had been automatically changed in the project file when I opened it without having R2 installed.

Community
  • 1
  • 1
JumpingJezza
  • 5,498
  • 11
  • 67
  • 106