How to Create SSRS 2012 Reports using Visual Studio 2019

1
votes

The customer I am consulting at is running their ERP and SSRS on SQL Server 2012. They're currently using Visual Studio 2010 Shell to create their SSRS reports.

I've been able to upgrade my Visual Studio to 2019 Professional. I can create SSRS reports in VS 2019, but when I try and upload the file to the reporting services web site, it fails saying I'm using a new version of Reporting Services (DUH).

Is there a way I can create SSRS 2012 reports (RDL) using Visual Studio 2019.

1
sql-servervisual-studioreporting-services
How are you trying to "upload" the file? Normally you deploy the project/report, not upload it. – Larnu
As far as I am aware, as well, the Reporting Service Extension for Visual Studio 2019 (there is no SSDT any more) supports SQL Server 2012+. Certainly I haven't read any material that says otherwise (I normally keep up to date on these, like when Microsoft (stupidly) removed it from SSDT 2017 in V 15.8.1 and promptly returned it in V15.9.0), nor have I heard anything from other communities to suggest it does not support 2012. – Larnu
Larnu, yoe when i do a regular Upload File it tells me the RDL File is newer and cannot upload – Marty Nahtygal
Here are the Versions i have installed on Visual Studio 2019 Pro -- SSIS 15.0.1528.0, SSDT 16.061908.27190, SSRS 15.0.1528.0 – Marty Nahtygal
Again, what do you mean "upload". Why aren't you using the deploy process? – Larnu

1 Answers

3
votes

In the Reporting Properties (DEBUG --> Reporting Properties), change the Target Server Version setting and choose SQL Server 2008 R2, 2012 or 2014.

enter image description here