Bewerken

Share via

Convert Data Sources (Report Builder and SSRS)

  • Artikel

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 paginated report definition (.rdl) files in Microsoft Report Builder, Power BI Report Builder, and in Report Designer in SQL Server Data Tools.

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.

Related content