Export (0) Print
Expand All

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).

Note 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.

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 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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft