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

user_5993206 0
Viewed 7666

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!

ssrs-2008-r2 rdl reporting-services build msbuild
2 Answers

Using Visual Studio 2017.

  1. Right click on Project then Go to Properties.

Project Properties

  1. Change TargetServerVersion to any of the following then click OK

    SQL Server 2008

    SQL Server 2008 R2, 2012 or 2014

TargerServerVersion

  1. This step is crucial. when you are done with the design.

    • Right click RDL or project and click Build.

Build

depending on build configuration you should have rdl file created for you in the follwing path.

\bin\Release\report1.rdl

\bin\Debug\report1.rdl
user_20496490
Related