How to: Convert a Data Source from Embedded to Shared (Report Builder 3.0 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 3.0 and SSRS).
Note
You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. 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 3.0 (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 How to: 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.