How do I update my SSRS 2005 draft report to use modern versions of SSRS?
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 am trying to update and edit a collection of old report files for use with the current version of SSRS. The project update is (apparently) OK and the reports can be viewed in the SSDT-BI Report Editor.
But whenever I try to save any of these reports, a window appears with the error "Unknown report version: 9.0".
I suspect 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 configure to get the files useful again. Perhaps an XML schema name or something similar?
The main namespace in RDL files currently http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition
"Version 9.0" probably corresponds to SQL Server 2005 because it was the major version number of that version of SQL Server and 2005 can be found in the schema namespace.
This document says that:
Reports created in any previous version of Service reporting 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 update these reports to be fully compatible with modern versions of SSRS?
source to share
I downloaded "SQL Server 2012 Express with Advanced Services" from MSDN and installed the SSRS report editing tools and then used them to open and save the reports. (It also works to download SSDT-BI for Visual Studio 2012 (version 11.0.5583.0) by following the links on this Microsoft webpage.other version of SSRS editors based on VS2012 instead of VS2010.)
This updated the .rdl files from the 2005 reporting schema to the 2008 reporting schema (I suppose there were no actual schema changes between SSRS 2008, 2008 R2 and 2012).
The updated reports could then be opened and edited in SQL Server 2016 tools, which update them again to the SSRS 2016 schema.
source to share
I followed the steps below to migrate old reports. Opened an old SSRS report project in VS2017 (not a solution file). He asks for migration. Then open the rdl file in design mode, it will update the report definition schema. Save the report. You can then open the project file in VS2015 or VS2017 with the updated report definition schema.
source to share