October 24, 2018 at 12:15 pm
I've started moving my development over to SQL Server Data Tools 2017 which is working great for SSIS, but now that I need to build a Report Project for our SQL Server 2014 SQL Server it's giving me some fits. First I built a new Report Project and changed the Target Server Version to SQL Server 2008 R2, 2012 or 2014 then built a new Report. It works fine in DT, but when I deploy it to the Report Server it says the version is incompatible. Looking at the RDL XML it has this as the Report Definition:
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
So I went into Report Builder 3.0 and built a new blank Report which had this:
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
And I added this to my Report Project in Data Tools. I built out the report, deployed it, and the same issue. At some point the RDL was upgraded because now has the 2016/01 Report Definition reference where it was 2010/01 before.
Is it possible to build a report definition in Data Tools 2017 for older versions of Reporting Services? If so how ? Thanks.
October 24, 2018 at 12:23 pm
samalex - Wednesday, October 24, 2018 12:15 PMI've started moving my development over to SQL Server Data Tools 2017 which is working great for SSIS, but now that I need to build a Report Project for our SQL Server 2014 SQL Server it's giving me some fits. First I built a new Report Project and changed the Target Server Version to SQL Server 2008 R2, 2012 or 2014 then built a new Report. It works fine in DT, but when I deploy it to the Report Server it says the version is incompatible. Looking at the RDL XML it has this as the Report Definition:<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2016/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
So I went into Report Builder 3.0 and built a new blank Report which had this:
<Report xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:cl="http://schemas.microsoft.com/sqlserver/reporting/2010/01/componentdefinition" xmlns="http://schemas.microsoft.com/sqlserver/reporting/2010/01/reportdefinition">
And I added this to my Report Project in Data Tools. I built out the report, deployed it, and the same issue. At some point the RDL was upgraded because now has the 2016/01 Report Definition reference where it was 2010/01 before.
Is it possible to build a report definition in Data Tools 2017 for older versions of Reporting Services? If so how ? Thanks.
Can;t be sure, but if you use the RDL file in the project file to upload to your SSRS Server, you'll have this problem. You would need the one from the bin\Debug folder within your project folder instead, as that's the default location for when the project does a "build" on the report. The RDL file for opening the project remains in the current format, and only a BUILD of the report produces the down-level version for actual deployment. Just want to be sure you're aware of that....
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
October 24, 2018 at 12:27 pm
sgmunson - Wednesday, October 24, 2018 12:23 PMCan;t be sure, but if you use the RDL file in the project file to upload to your SSRS Server, you'll have this problem. You would need the one from the bin\Debug folder within your project folder instead, as that's the default location for when the project does a "build" on the report. The RDL file for opening the project remains in the current format, and only a BUILD of the report produces the down-level version for actual deployment. Just want to be sure you're aware of that....
Steve,
Oh gosh not sure how I missed that, yes I built it and there's the report in Debug within the correct format. I didn't even think to check that. Thanks!
Sam
October 24, 2018 at 2:19 pm
samalex - Wednesday, October 24, 2018 12:27 PMsgmunson - Wednesday, October 24, 2018 12:23 PMCan;t be sure, but if you use the RDL file in the project file to upload to your SSRS Server, you'll have this problem. You would need the one from the bin\Debug folder within your project folder instead, as that's the default location for when the project does a "build" on the report. The RDL file for opening the project remains in the current format, and only a BUILD of the report produces the down-level version for actual deployment. Just want to be sure you're aware of that....Steve,
Oh gosh not sure how I missed that, yes I built it and there's the report in Debug within the correct format. I didn't even think to check that. Thanks!Sam
Glad I could help. Ya never know when one extra pair of eyes can help ya get past something... and especially when it's the stereotypical "obvious" thing. Just seems like that's when I most need that extra set of eyes...
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply