1.
Right click the Database Fields node in the Field Explorer window.
2.
Select Database Expert from the pop-up menu. The Database Expert dialog
should appear.
3.
Click the plus(+) sign next to the Create New Connection node from the
Available Data Sources.
4.
Click the plus(+) sign next to the OLE DB (ADO) node. A dialog box
should appear.
5.
Select SQL Native Client from the Provider list and click the next
button.
6.
Enter your SQL Server name, a valid user id and password. Select
AdventureWorks as the database and click the Next button.
7.
Click the Finish button.
8.
Click the plus(+) sign next to the AdventureWorks database. Add the
following tables to the report by clicking on the table and then use the arrow
button (>) to move the table to the Selected Tables list. The tables are
Person.Address, Person.Contact, Person.StateProvince, HumanResources.Employee, and
HumanResources.EmployeeAddress.
9.
Click the OK button.
Figure 3