Hi I need to convert my report from SSRS 2008 to SSRS 2012.
The abc database is still on a SQL 2008 server. When I run the SERVERPROPERTY in SSMS , I get the following result :
productversion productlevel edition
10.0.4000.0 SP2 Standard Edition (64-bit)
I opened and saved a 2008 rdl file in SSDT . However The XML still shows the report as 2008 report and not a 2012 report as shown below.
<?xml version="1.0" encoding="utf-8"?>
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2008/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
Do we need to upgrade the server that holds ABC database to sql 2012 or even when the above XML shows sqlserver/reporting/2008/01/reportdefinition , it is still converted into sql 2012 report.
Confused . Please help .