How to Use Report Designer in SQL Server Data Tools


show more Report Designer is a report layout option that is linked into Visual Studio, and it lets existing Visual Studio users learn how to incorporate data stored in Reporting Services into a cohesive package. This video walks you through the steps for using Report Designer in SQL Server Data Tools after you have installed SQL Server Client Configuration Tools on your machine. show less
please wait ...

Using Report Designer in SQL Server Data Tools

We've been using Report Builder all along to create these reports, but another option that's available is to use Report Designer, which is the name for the report layout option that is integrated into Visual Studio. Now, unlike Report Builder, you can't just open this from this Report Manager website. It actually requires installation on your machine called SQL Server Client Configuration Tools. It's a little odd to describe because you don't actually open a tool called Report Designer. If you have the SQL Server 2008 R2 tools installed as I do, you'd get to it by opening up what's called the Business Intelligence Development Studio, or BIDS.

But in SQL Server 2012, there is no BIDS; this time around it's called the SQL Server Data Tools Program. If I open that up, it's going to look like it's opening up Visual Studio, because really, it is integrated inside that. Now, as I mentioned at the start of the course, don't get caught up in thinking tha...

Using Report Designer in SQL Server Data Tools
Video duration: 9m 34s 3h 44m Advanced

Viewers:

Report Designer is a report layout option that is linked into Visual Studio, and it lets existing Visual Studio users learn how to incorporate data stored in Reporting Services into a cohesive package. This video walks you through the steps for using Report Designer in SQL Server Data Tools after you have installed SQL Server Client Configuration Tools on your machine.

Subjects:
Developer IT
Software:
SQL Server
Author:
please wait ...