RDL XML name space definition

My 2008 R2 report manger DB contains mixed set of reports with 2008 and 2010 XML name space definitions. Is there a way to "update" RDLs with 2008 definitions to 2010.

All this headache is driven by a requirement to display report parameters that have been prompted for and are not internal or hidden.

Tom

September 1st, 2015 5:39pm

Hi Tom,

Based on my understanding, you want to upgrade SSRS 2008 R2 file to 2010, right?

In Reporting Services, a report definition 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. The only way to upgrade report a report definition file is to open an .rdl file in Report Designer in SQL Server Data Tools (SSDT). In this way, the report will be upgraded to the current namespace automatically.

In your scenario, you can identify the RDL schema version on the report server, then specify the deployment properties with the report server which supports 2010 report definition. For more information, please refer to articles below:
Upgrade Reports
Find the Report Definition Schema Version (SSRS)

Since you mention you want to display the report parameter which is prompted for, please open the report in report designer or report builder, then check the report parameter properties under Report Data pane. Check if the visibility is visible, and the parameter has dependence on other parameters.

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

Free Windows Admin Tool Kit Click here and download it now
September 1st, 2015 9:45pm

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

Other recent topics Other recent topics