Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Are SSRS Reports supported in Visual Studio 2010 or 2012?

I haven't seen anything in the release notes, has anyone determined if there has been any improvement in this area? It's kind of surprising MS wouldn't support .resx files out of the box for SSRS reports.

The only option I see is creating a separate class library and using it to retrieve resource strings as shown in this article, which doesn't mention which version of SQL Server or VS they are using. (relating to the original question, it changed into just getting reports working in vs 2012)

I tried the Visual Studio 2012 Pro trial and the migration of the report project failed.

ProjectName.rptproj: The application which this project type is based on was not found.

When the project opens in Visual studio 2012 the Report Project says (incompatible) and text below it says

This project is incompatible with the current edition of Visual Studio.

like image 903
lko Avatar asked Feb 18 '23 21:02

lko


1 Answers

I got reports and a report project (.rtproj) to work in Visual Studio 2010 with SQL Server 2008 R2! It will presumably work in any combination of VS 2010/2012 with SQL Server 2008 (R2) or SQL Server 2012.

  1. Install Visual Studio 2010 PLUS SP1.
  2. Install SQL Server Data Tools (SSDT)
  3. Install SQL Server 2012 with Data Tools and Reporting Services. (I used the trial version)

Now I can use Visual Studio 2010 for editing and deploying reports, even to SQL Server 2008 R2 (and likely other versions).

For older SQL Server Reporting Service versions there is still a question of whether there is anything new or unsupported in the VS10/12 report editor project.

like image 56
lko Avatar answered Feb 20 '23 19:02

lko