Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Missing Business Intelligence Project type in Visual Studio 2010

When I use visual studio 2008 and do a new project I can select the type of project as Business Intelligence project. From here I can select a report server project.

I noticed that with visual studio 2010, this does not exist any longer. Tried doing some googling about it and got this:

http://social.msdn.microsoft.com/Forums/en-CA/vsreportcontrols/thread/f2d272b1-a7f5-41b7-9cb8-a0958c192d31

But it may be outdated. I know this stuff usually comes from SQL Server not Visual Studio, but I have SQL Server 2008 installed as well (Developers edition locally).

So do we have any Visual Studio / SQL Server MS folks that can help with something like this. I do not want to create a C# report project.

like image 872
JonH Avatar asked May 28 '10 19:05

JonH


People also ask

Can I download Visual Studio 2010 for SQL Server business intelligence?

I have VS 2010 on my machine. Visual Studio 2010 is no longer supported for SQL Server Business Intelligence tools. You will not find a download link unless Google or some other site might have cached it somewhere. You will need to download Visual Studio 2012 SSDT-BI or 2013, these support BI projects for SQL Server 2012 and 2014 respectively.

Why can't I open the project in Visual Studio 2010?

You upgrade the project to the format that is used by Visual Studio 2010. You can't open the project in Visual Studio 2010. In the Solution Explorer window, the project name will be dimmed with the word (unavailable) in parentheses next to the name of the project. You can't open the project in SQL Server BIDS after you upgrade the project.

What is business intelligence in SQL Server?

SQL Server Business Intelligence (BI) is a series of tools for turning raw data into information that companies can use to make decisions. What do you learn in business intelligence?To summarize, here are the main… How do I open Business Intelligence Development Studio in Visual Studio 2019? How do I create a SSRS report in Visual Studio 2019?

How do I open SSIs in Visual Studio Management Studio?

In Visual Studio, click New> Project on the File menu. In the Installed Templates area of ​​the New Project window, expand Business Intelligence and click Integration Services. How do I open SSIS package in SQL Server Management Studio?


2 Answers

Just read that the SQL team is generally behind the vs.net team. So you have to use Visual Studio 2008 to develop reports. I guess the next version of SQL should bring an add on to VS.

See the graph also from MSDN: enter image description here

like image 113
JonH Avatar answered Sep 19 '22 16:09

JonH


You need to install SQL Server 2012 with Reporting Services to enable Business Intelligence projects in Visual Studio 2010. You also need to install SSDT for Visual Studio 2010 to work on the same.

like image 34
sansy Avatar answered Sep 22 '22 16:09

sansy