How to upgrade SSRS 2005 report project for use with modern SSRS versions?

user_531971 0
Viewed 5590

I have installed SQL Server Data Tools for Business Intelligence (SSDT-BI) version 14.0.61705.170 and SQL Server Reporting Services (SSRS) version 14.0.608.142.

I'm trying to upgrade and edit a collection of older report files for use with the current version of SSRS. The project upgrades (apparently) ok, and the reports are viewable in the SSDT-BI report editor.

But whenever I try to save any of these reports, an error message box pops up which says "Unknown Report Version: 9.0".

I suspect it's because the RDL files are so old, but I don't see 9.0 anywhere in the RDL file so I'm not sure what I need to tweak to make the files savable again. Perhaps an XML schema name or similar?

The main namespace in the RDL files is currently http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition

"Version 9.0" probably corresponds to SQL Server 2005 since that was the major version number of that release of SQL Server, and 2005 can be found in the schema namespace.

This document says that:

Reports that were created in any previous version of Reporting Services can be upgraded. This includes the following versions:

  • SQL Server 2008
  • SQL Server 2008 R2
  • SQL Server 2012
  • SQL Server 2014

So... how can I upgrade these reports for full compatibility with modern SSRS versions?

ssrs-2016 ssdt-bi reportingservices-2005 migration
2 Answers

I followed these steps to migrate old reports. Opened the old SSRS report project in VS2017 (not the solution file). It asks for the migration. Then open the rdl file in designer mode, it will upgrade the definition schema of the report. Save the report. You can then open the project file either in VS2015 or VS2017 with upgraded report definition schema.

user_99153030
Related