Report Parts

Report Parts helps users to create and publish report item templates that user may want to reuse across multiple reports. With this functionality, Report items such as tables, charts, maps, indicators, and other report items can be published and reused as report parts in different reports.

To demonstrate the usage of the Report Part feature, we created a new table called Product_Details_Table to display the product details.

Consider this scenario, we need to use the Product Details table in various reports. However, creating this table for each report is a tedious process. To address this case, we are publishing the Product Details table as a report part and reusing it in multiple reports.

Publishing the Product Details Table as a Report Part

1. Click on the Publish Report Part option from the dropdown in top-right corner of the report designer page.
2. This action will open the Publish Report Part dialog.
3. The report items present on the designer surface will be listed in the Report part dropdown.
4. Select the Product_Details_Table report item from the dropdown, name the report part as Product_Details_Table in the Name field, add description if you want and click the Publish button to publish the Product_Details_Table report part.

Note: The Datasource, Dataset and the Query parameters associated with the widgets alone will be published along with the report part whereas Dataset bind with the scope of the expressions and Report parameters will not be published with the report part.

Reusing the Published Report Part in other Reports

Create a new report and in that we will use the Product_Details_Table report part to demonstrate this feature.

1. Find the Product_Details_Table report part under the Report Parts tab in the left side of the Designer surface.
2. Drag and drop the Product_Details_Table report part into the Designer surface.
3. Dataset and query parameters associated with the Product_Details_Table report part gets populated in this report.
4. By using this Product_Details_Table report part, I have created a new report to showcase the Product Details.

Update Report Part

You have made changes to the Product_Details_Table report part and have published it. If you want the updated changes to be reflected in other reports that use this Product_Details_Table report part, right-click on the Product_Details_Table in the specific report. This action will display the Update Report Part option.

Click on the Update Report Part option; the updated changes in the Product_Details_Table report part will be reflected in your report.

A confirmation alert will appear when you try to update a report part that has a Tablix or Rectangle with child report items, if there is a change in the width or height of those report part items in the current report design or downloaded report part.

For other report items, the downloaded report part will be updated to match the current report part layout.

Here’s what to expect:

If the current size of a Tablix or Rectangle with child items is smaller than the downloaded report part, the following alert will be shown:

If the current size of a Tablix or Rectangle with child items is larger than the downloaded report part, the following alert will be shown:

Selecting Yes will update the width and height of the Tablix or Rectangle with child items based on the downloaded report part. It may affect the layout of these report parts and the report design.

If you choose No, the downloaded report part will try to fit into the current layout of report parts which has Tablix or Rectangle with child items. It may affect the layout of these report parts and the report design.

Download the above report design from link.