Export (0) Print
Expand All

Report Parts and Datasets in Report Builder

In Report Builder, the easiest way to include data in a report is to add report parts from the Report Part Gallery. Report parts contain the datasets that they depend on, which are known as dependent datasets. Dependent datasets are based on shared data sources and can be either embedded datasets or shared datasets.

Note Note

Report parts are self-contained report items that are stored on the report server and can be included in other reports. Use Report Builder to browse and select parts from the Report Part Gallery to add to your reports. Use Report Designer or Report Builder to save report parts for use in the Report Part Gallery. For more information, see Report Parts (Report Builder and SSRS) and Report Parts in Report Designer (SSRS) on the Web at microsoft.com.

Another easy way to include data in a report is to use a shared dataset. For more information, see Report Embedded Datasets and Shared Datasets (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.

When you add a report part to your report, the dependent datasets that it contains are also added to your report. Because a report part might include a rectangle that contains many other report items, it can add multiple dependent datasets to your report. Each shared dataset is an independent reference; the shared data source that it depends on is not added to your report. Each embedded dataset also adds the embedded or shared data source that it depends on.

The credentials for an embedded data source are not saved as part of the report part. If an embedded data source is added to your report, you will be prompted for credentials when you run the report. To avoid being prompted for credentials, use report parts that are based on shared data sources with stored credentials.

After you add a report part to your report, the added datasets are no different than embedded or shared datasets that you create. You can view the additional datasets in the Report Data pane. Embedded datasets appear under the corresponding shared data source and shared datasets appear under the Shared Datasets folder.

Arrow icon used with Back to Top link Back to Top

After you add report parts to your report, you might preview it and decide to make some changes to the data. What you can change depends on the type of dataset that you are working with.

To change data and data options for an embedded dataset, you can edit the dataset properties, including the query, just as if you had created the dataset yourself.

To change a data and data options for a shared dataset, you can change the shared dataset definition on the report server only you have sufficient permissions. You can also customize the instance of the shared dataset in your report by adding filters, adding calculated fields, and changing data options such as case sensitivity. For more information, see Embedded and Shared Datasets (Report Builder and SSRS).

For more information about how to change the definition of a shared dataset or how to show the latest data changes for a shared dataset in your report, see Create a Shared Dataset or Embedded Dataset (Report Builder and SSRS) and Add, Edit, Refresh Fields in the Report Data Pane (Report Builder and SSRS).

Arrow icon used with Back to Top link Back to Top

When you publish a report item that has dependent datasets, you have the option to publish each dataset as a shared dataset or as an embedded dataset that remains embedded in the report item.

When you select the shared dataset option, the dataset is saved to the report server as a shared dataset definition. In your report, every report item that uses that dataset is updated to point to the shared dataset that is now on the report server. Two things happen as a result:

  1. In the Publish dialog box, each shared dataset that has been published is removed from the list of items that are available to publish.

  2. When you exit Report Builder or start a new report, you are prompted to save your report. If you do not save your report, the next time you open this report and publish report items, you might publish new copies of the same datasets. To prevent saving multiple copies of shared datasets to the report server, we recommend that you save the report.

Important note Important

To ensure that you and others can continue to successfully use data from a shared dataset, you must understand the principles behind securing report items. For more information, see Secure Shared Dataset Items.

Arrow icon used with Back to Top link Back to Top

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

Community Additions

ADD
Show:
© 2014 Microsoft