Can SSDT in VS2010 edit SSRS 2005 RDL files?
I have installed the SQL Server Data Tools from the SQL Server 2012 installation media. I now have Microsoft SQL Server Reporting Services Designers Version 11.0.2100.60 running inside of Visual Studio 2010 IDE. According to this page I should be able to author 2005 RDL schema files. http://msdn.microsoft.com/en-us/library/ee635898.aspx And According to this page... http://msdn.microsoft.com/en-us/library/ms170438.aspx You can also continue to open and edit reports that use the 2005 and 2008 RDL schemas in SQL Server Data Tools (SSDT). However, if you add a report item that is not compatible with the schema used by a report, the report will be automatically upgraded to the 2010 RDL schema. So I open a RDL file that is in the 2005 RDL format and just save it without making changes and it gets updated to a 2008 RDL file format. Am I doing something wrong or is the documentation referenced above incorrect? Thanks
May 15th, 2012 4:22pm

Hi StevenIBSI, In Reporting Services, a report definition (.rdl) file includes a reference to the RDL namespace that specifies the version of the report definition schema that is used to validate the .rdl file.When we open an .rdl file in Report Designer in SQL Server 2012 Data Tools (SSDT), if the report was created for a previous namespace, Report Designer automatically creates a backup file and upgrades the report to the current namespace. Additionally, if we just view and edit the XML code of the report and not view the report designer, the RDL namespace will not be upgraded. Otherwise, the report RDL namespace will be upgraded even if we dont add any items to the report. References: Upgrade Reports Hope this helps. Regards, Mike Yin
Free Windows Admin Tool Kit Click here and download it now
May 20th, 2012 8:27am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics