Convert a Data Source from Embedded to Shared (Report Builder and SSRS)

Each data source in the Report Data pane is embedded and specific to the report or is shared. In Report Builder, a shared data source points to a published shared data source on a report server or SharePoint site. In Report Designer, a shared data source points to a shared data source in the Shared Data Sources folder in Solution Explorer.

For more information about the differences between embedded and shared data sources, see Embedded and Shared Data Connections or Data Sources (Report Builder and SSRS).

For more information on how to create a shared data source, see Create an Embedded or Shared Data Source (SSRS).

Note

You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

Report Designer

To convert a data source from embedded to shared

  • In the Report Data pane, right-click the data source, and then click Convert to Shared Data Source.

    Note

    If the Report Data pane is not visible, on the View menu, click Report Data. If the pane opens as a floating window, you can dock it. For more information, see Dock the Report Data Pane in Report Designer (SSRS).

    In the Report Data pane, the data source icon changes to the shared data source icon. In Solution Explorer, a shared data source with the same name appears under the Shared Data Source folder.

To convert a data source from shared to embedded

  • In the Report Data pane, right-click the data source, open the Data Source Properties dialog box, and then click Embedded Connection. Enter the required information.

    In the Report Data pane, the data source icon changes to the shared data source icon.

Report Builder

To convert a data source from embedded to shared

  • In the Report Data pane, right-click the data source to open the Data Source Properties dialog box, and then click Embedded Connection. Enter the required information.

    In the Report Data pane, the data source icon changes to the shared data source icon.

To convert a data source from shared to embedded

  • In the Report Data pane, right-click the data source, open the Data Source Properties dialog box, and then click Embedded Connection. Enter the required information.

    In the Report Data pane, the data source icon changes to the shared data source icon.

See Also

Concepts

Manage Report Data Sources

Data Connections, Data Sources, and Connection Strings (SSRS)