Define the data source

Once you have created an empty report for your project, you need to define the data source for the query.

To define the data source

1. In Microsoft Visual Studio, navigate to the Report Data pane > Data Sources.

2. Right-click on Data Sources and select Add Data Source.

   The Data Source Properties dialog box appears.

   

3. Select Embedded connection.

4. Select Build.

   The Connection Properties dialog box appears.

   

5. In the Connection Properties dialog box:

   1. In the Server name field, select the server you want to use.

   2. Select Select or enter a database name and enter or choose the database you want to connect to.

   3. Select OK.

6. The Connection Properties dialog box closes and the Data Source Properties dialog box appears with the Connection string field populated.

   

7. Select OK.