Databases Reference
In-Depth Information
Figure 6-6.
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 starting with SQL Server 2008 R2 (and
continuing in SQL Server 2012) it became very easy via the ADO.NET (SqlClient) and OLE DB data providers.
However, SQL Server 2008 R2 and above also add a new SQL Database-specific provider. You'll see this shortly.
Creating the SQL Database 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
6-7
.
Figure 6-7.
Adding a data source
