Report designer in 2014 Express

Question

Where is a report designer in 2014 Express version?

Thanks

Answer 1

There are several versions of SQL Server Express Edition. To the best of my knowledge, only SQL Server Express Edition with Advanced Services comes with Reporting Services.

The designer is know as SQL Server Data Tools and uses the Visual Studio shell. If a full version of Visual Studio was already installed when you installed SQL Server, the installer should recognize it and simply add options to the existing VS install.

In any case, searching the start menu for for "Data Tools" or "Visual Studio" will get you to the designer... Assuming you have it installed.

As a separate option, you can also download SQL Server Report Builder

---

Jason Long

Answer 2

I have installed SSRS 2014 Express with Advanced Services, or so I believe. But I didn't find SQL Server data Tools. What do I need to verify?

Answer 3

Even if you did install the Advanced Services version, you still need to make sure that it all of the services were included when doing the actual install.

If searching the start menu didn't get you any results, odds are it wasn't installed. The easiest thing is to re-install SQL Server Express, taking the "add features" option. It'll step you through the install and help identify what's already installed and what isn't and allow you to add to what's already installed.

(Sorry... It's been a little while since I've done my last install so I'm not 100% on the exact wording.)

---

Jason Long

Answer 4

Hi markgoldin,

According to your description, you installed SSRS 2014 Express with Advanced Services, but you could not find SQL Server Data Tools.

As Jason mentioned above, if SQL Server Data Tools is installed, it will be listed in Start menu. Please make sure you have installed it.

In addition, the new SQL Server Data Tools for BI (SSDT-BI) is used to create SQL Server Analysis Services (SSAS) models, SSRS reports, and SSIS packages. The new SSDT-BI supports SSAS and SSRS for SQL Server 2014 and earlier. In the pre-release version of SQL Server 2014, SQL Server Setup doesn’t install SSDT-BI. Instead, we need to download SSDT-BI separately from the Microsoft Download Center.

For more information about SQL Server Data Tools, please refer to the following document:
http://blogs.technet.com/b/dataplatforminsider/archive/2013/11/13/microsoft-sql-server-data-tools-update.aspx

If you have any more questions, please feel free to ask.

Thanks,
Wendy Fu
   
If you have any feedback on our support, please click here.   

Answer 5

I downloaded and installed SSDT fro VS 2012. I still dont Data Tools in SQL 2014. When I opened VS and tried to create a new project I did not see anything related to BI Report Designer.

Answer 6

I ran installation again. Everything was already selected. Please dont mark anything as a proposed answer. It's not for you to decide.

Answer 7

Please dont mark anything as a proposed answer. It's not for you to decide.

Actually it is for him to decide. That is exactly what a "proposed answer" is. Any one can choose a response as a proposed answer. It's on you, the OP,  to choose 1 or more responses as the "actual answer".

---

Jason Long

Answer 8

Hi markgoldin,

For SQL Server 2014, we can use SSDT BI in Visual Studio 2013 and it includes the Visual Studio Project Templates for Analysis Services, Integration Services, and Reporting Services. It can be downloaded from: http://www.microsoft.com/en-us/download/details.aspx?id=42313.

For more information about SQL Server database tooling in Visual Studio 2013, please refer to the following document:
http://msdn.microsoft.com/en-us/dn864412

If you have any more questions, please feel free to ask.

Thanks,
Wendy Fu