Databases Reference
In-Depth Information
■
SQL Server Data Tools is a central and unified development environment integrated into Visual Studio which
allows database developers and DBAs to perform all of their database design work all within a single tool.
Note
Creating a Report
The process of creating reports that access data from SQL Database is the same as for reports that access local data,
with one slight difference: the connection to the data. The example in this chapter for creating a report will use SQL
Server Data Tools, which is installed with SQL Server 2012. SQL Server Data Tools (SSDT) is the new BIDS (Business
Intelligence Development Studio) for SQL Server 2012. To create a report, follow these steps:
1.
From the Start menu, select All Programs
➤
Microsoft SQL Server 2012
➤
SQL Server
Data Tools. When SSDT opens, create a new Report Server Project. From the New Project
dialog select the Reporting Services template and then select the Report Server Project. In
Figure
6-5
the project is called AzureReport, but feel free to change the name. Click OK.
Figure 6-5.
New Report Server Project
2.
In Solution Explorer, right-click the solution and select Add
➤
New Item from the
context menu.
3.
In the Add New Item dialog, select the Report template, and click Add,
as shown in Figure
6-6
.
