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!
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.
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.
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.
You can convert 2016 rdls to 2008 r2 version by following below simple steps :
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With