• Article

Data Source Properties Dialog Box, General (Report Builder 2.0)

Select General on the Data Source Properties dialog box to select a shared data source from a report server or to create or modify connection information for a data source embedded in the report.

Options

  • Name
    Type the name of the data source. The data source name must be unique within the report. By default, a general name, such as DataSource1 or DataSource2, is assigned to the data source.

  • Use a shared connection
    Select this option to browse to a shared data source that has been published to a report server.

    After you select a data source from a report server, Report Builder 2.0 maintains a connection to this report server. For more information, see Report Servers and SharePoint Report Servers (Report Builder 2.0).

  • Use a connection embedded in my report
    Select this option to create a data source that is used only by this report.

  • Type
    Select a data processing extension. The list displays all registered extensions.

  • Connection string
    Enter a connection string for the data source. Click Build to build the connection string using the Connection Properties dialog box. Click the Expressions (fx) button to edit the expression.

  • Use a single transaction when processing the queries
    Select this option to indicate that datasets that use this data source are run in a single transaction against the database. To include transactions for subreports that use the same data source, select the subreport, and in the Properties pane, set MergeTransactions to True.