Bind a Report to a Database
- 2 minutes to read
This document describes the steps required to connect a report to a database.
To bind a report to a database, do the following.
- Create a new report.
Right-click the report and select Edit… in the context menu. In the invoked dialog, expand the Data Source drop-down and click the Add New button.
On the first page of the invoked Data Source Wizard, specify the data connection to be used. If it is absent in the list containing existing connections, select No, I’d like to specify the connection parameters myself and click Next.
On the next page, specify the data source type. Select Microsoft SQL Server and click Next to proceed.
This page allows you to specify connection string parameters specific to the selected data source provider. Depending on the data provider selected, it may be necessary to specify additional connection options (such as authentication type and database name) on this page.
Click Next to proceed.
If server authentication is required for the selected database type, the next page will prompt you to specify whether or not you want to save the user credentials along with the connection string.
Select the required option and click Next.
On the next page, you can construct an SQL query to obtain data from the database, or select a stored procedure.
To construct an SQL query, click Run Query Builder…
In the invoked Query Builder window, select an item from the list of available tables on the left and drop it onto the list of data tables to be used.
Enable the check box near the added table to include all of its fields in the data view.
Click OK to exit the Query Builder. Click Finish to exit the Data Source Wizard.
The newly created SQL data source will be displayed in the Components node of the Report Explorer. Additionally, the hierarchy of the data source will be reflected by the Field List.
