Data Source (General Tab, Report Designer)

Use the General tab of the Data Source dialog box to display and modify connection information for a data source in the report.

The following table describes the other tab in the Data Source dialog box.

Topic Description

Data Source (Credentials Tab, Report Designer)

Describes the Credentials tab of the Data Source dialog box.

Options

  • Name
    Type the name of the data source. The data source name must be unique within the report.
  • Type
    Select a data processing extension. The list displays all registered extensions.
  • Connection string
    Type a connection string for the data source. Click Edit to build the connection string using the Connection Properties dialog box.
  • Use shared data source reference
    Select Use shared data source reference to link to a shared data source. If Use shared data source reference is selected, Type and Connection string are disabled.
  • Reference
    Select a shared data source. To edit the selected data source, click Edit.
  • Use single transaction
    Select Use single transaction to indicate that datasets that use this data source are executed in a single transaction.

See Also

Reference

Report Designer F1 Help

Other Resources

Defining Report Datasets

Help and Information

Getting SQL Server 2005 Assistance