Hi

When I try to open a sample report ( Report Recipe - Sparklines - R2.rdl), which is according to page 131 based on Reporting Services 2008, I get following error:

"The report definition has an invalid target namespace 'http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition' which cannot be upgraded"

I currently use version 10.0.2531.0 of Microsoft SQL Server Reporting Services, which has name Space:

xsd:schema targetNamespace="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://schemas.microsoft.com/sqlserv...portdefinition" elementFormDefault="qualified">

• What do I have to do use the sample reports?
• Can I upgrade to version 2009?
• I yes, how can I do this?

Thank you fpr help

This is an SQL 2008 R2 report, and I was able to open it using Report Builder 3.0. The version numbers are confusing, but search for Report Builder 3.0, and use it unconnected to a report server, unless you have SSRS R2 installed.

Hi rparge

Thank you for the workaround, it works fine for this tutorial. I have not installed SSRS 2008 R2.
The namespace 'http://schemas.microsoft.com/sqlserver/reporting/2009/01/reportdefinition' probably is from a CPT version, because version 2008 R2 has 'http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition' namespace.

Correct, the 2009/01 RDL namespace was only used by earlier 2008 R2 CTP versions. It will automatically upgrade to the final 2010/01 RDL namespace when publishing the report to a 2008 R2 report server, or loading the report in Report Builder 3.0 / BIDS 2008 R2.

HTH,
Robert