Mehrad
Mehrad

Reputation: 4203

Missing Reporting Server templates in Visual Studio 2013 + Business Intelligence SSDT

The other day I have installed Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2013 (SSDT: Replacement for BIDS) and started using reporting features in VS2013.

Successfully created a project using Report Server Project Wizard template.

However, later on I needed SQL Server 2014, then I downloaded and installed the developer edition. (in case if this might've caused the problem)

Now the Report Server Project templates are missing from VS2013 and I can't simply bring them back.

Now my VS2008 has the features that I want: enter image description here

But no trace of them in VS2013 Professional: enter image description here

Any suggestions?

Additional unsuccessful approaches I have taken

Upvotes: 6

Views: 7668

Answers (1)

Mehrad
Mehrad

Reputation: 4203

I have eventually fixed my issue by following Graham's suggestion on my question on his post Installing SQL Server Data Tools – Business Intelligence for Visual Studio 2012 by taking scorch earth approach and uninstalling every single edition of SQL that I had on my PC. The whole thing basically boils down to these three simple steps,

  1. Uninstall every SQL Server instance from your PC using Programs and Features in Control Panel

  2. Installed 32-bit edition of SQL Server 2014 Express (any other variation would work)

  3. Installing 32-bit SSDT-BI for Visual Studio 2013 and choosing Add features to an existing instance of SQL Server since the 32-bit versions match. If you got mismatch editions follow the post mentioned above. (there is no 64-bit variation for SSDT-BI since Visual Studio is also only available in 32-bit.)

Viola,

enter image description here

Upvotes: 3

Related Questions