Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Build tool to convert SSRS projects report RDL schema from 2016 to 2008 version

I have a number of SSRS reports that are currently in 2016 schema and need to be converted to 2008 R2 schema upon build.

Does anyone know how I can achieve this? Is it actually possible to do this? Does Microsoft provide a tool for this purpose?

It is difficult to find information on this, so any help would be greatly appreciated!

Thanks all!

like image 338
Mark Avatar asked May 19 '17 04:05

Mark


People also ask

How do I change RDL version?

Show activity on this post. I think quickest way is to go to the Solution Explorer window, right click on your PROJECT and go to Properties. It will open the deployment window and the very last option should be TargetServerVersion that will allow you to change the Target version.

How do I upgrade RDL files?

When you open an . rdl file in Report Designer in SQL Server 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. This is the only way you can upgrade a report definition file.

How do I open an RDL file in Report Builder?

Firstly, open the RDL file of the report that you want to deploy in the report server from the Microsoft Report Builder tool. Then, connect it to the report server as depicted below by providing the report server URL and click on Connect. Then it starts connecting to the report server. Wait for a few minutes.


1 Answers

You can convert 2016 rdls to 2008 r2 version by following below simple steps :

  • Update Version 2016 to 2008 in first line.
  • Delete two lines of both opening and closing part of the ReportSection and ReportSections.
  • Delete complete ReportParametersLayout part.
like image 88
Shubham Yadav Avatar answered Sep 20 '22 16:09

Shubham Yadav