Database Reference
In-Depth Information
Figure 8-2.
Adding a report
At this point, you're staring at a blank report, but you also see a new Report Data tab displayed in
the Visual Studio IDE. Your task is to tell the report where to get its data from, and SQL Server 2008 R2
makes it very easy. Prior to SQL Server 2008 R2, you had a couple of data providers to choose from:
ADO.NET (SqlClient) and OLE DB. However, R2 added a new SQL Azure-specific provider. You see this
shortly.
Creating the SQL Azure Data Source
Continue with these steps:
1.
In the Report Data window, right-click the Data Sources node, and select Add
Data Source from the context menu, as shown in Figure 8-3.
Figure 8-3.
Adding a data source
