Report Parts in SSRS

Report Parts in SSRS help you to reuse the reports or Report Items in multiple reports. In this article, we will show you how to create and Publish Report Parts in SSRS, How to reuse them, and How to update the existing report parts with an example.

To demonstrate the steps involved in creating Report Parts in SSRS, We are going to use the previously generated report that we shown below. Please refer to Formatting Date and Time article to understand the report data and see Add Rectangle article to understand the rectangle configuration.

TIP: If you find any difficulty in creating a report in Report Builder. Please refer to Create New in Report Builder article to understand the same.

Sample Report Design

Let me show you the report preview. As you can see, it is pretty ordinary Table Report with formatted date and time, and it has the Address (inside the rectangle) on top of the report

Table Report View

Publish Report Parts in SSRS

Is was very easy to publish report parts from SSRS Report Builder. To do so, click on the Publish Report Parts option from the Menu.

Publish Report Parts Option

Selecting the Publish Report Parts button opens the following the pop-up window. It is always advisable to choose the second option because it gives you more control over what you are doing.

Review and Modify Report Parts before Publishing

After you select the second option, a new window called Publish Report Parts will be displayed. Here, it will show you the list of available report parts in SSRS.

Select Report Parts to Publish

Let me expand every SSRS report part. So that you can preview them

Review Each Report Component by expanding them

Next, add an accurate description that describes the report part functionality.

Provide Description to Each Report Part

Once you completed the review, please checkmark the required report parts and click the Publish button

Review All the Report Parts and click publish

Once you click the Publish button, a message will be displayed. It writes the number of report parts that are successfully published and failed.

Success message of publishing Report Parts

Use Report Parts in SSRS Reports

In this example, we will show you how to use the report Parts in SSRS. To demonstrate the same, we need an empty or blank report. So Please open the Report Builder, and select the New Report tab, and then select the Blank Report option.

As we showed below, we added a title as SSRS Report Parts Example, and an Execution time in Page Footer. Apart from that, we also formatted the text

Sample Blank Report

To use the existing SSRS report parts or Report Items, Please go to the Insert Tab, and click the Report Parts button

Click on the Report Parts Icon

Click on the Report Parts tab opens a new window called Report Part Gallery. You can use this window to search the report parts present in the Report Manager.

View Report Parts Gallery

Let me search for the Employee table. Once you got the required report part, double-click on it will automatically add that report part into a designer window.

Search Report Parts Gallery

You can search for the Company also!

As you can see from the below screenshot, we just added all the existing report parts (table, rectangle, Image) to this new blank report.

Add Report Parts to Table

let me show you the report preview

Table withReport Parts Preview

Let me show you what will happen if I change the Address color. Remember, whatever changes you made in this report belong to this only. But, if you publish the report parts, then the main report part will be updated.

Change Report Parts Color

And the report preview is:

Report Parts Preview

Now let me show you what will happen if I publish the report part from this report?

Publish Report Parts from Table

I think I forgot to mention the Report Parts folder. When you publish a Report Part for the first time, then the Report Manager will automatically add a new folder called Report Parts. This folder will hold all the report parts that we publish in a lifetime.

Report Parts Folder in Reporting Service

Let me show you the report parts inside the Report Parts folder.

Components in Report Parts Folder

Let me add the address report part to check whether the report part is updated or not. As you can see from the following screenshot, it is displaying the updated address (text color is red).

Add Rectangle Report Part

Update Report Parts in SSRS

Let me open the original one. In this example, we will make some changes to this table and show you what will happen to the dependent report?

As you can see, we had deleted the Yearly Income Column. Next, we published the SSRS report parts

Delete Columns from Report Parts

If you want that update to reflect in the dependent report. Within the second one, please click on the Check For Updates option from the main menu.

Check for Updates Option

Clicking the Check For Updates option displays a new message. If there are any report part updates, then View Updates button will display. Otherwise, it shows a message – 0 updates are available.

View Report Parts Updates

Once you click on the View Updates button, a new window called Update Report Parts will open. It will display the available report part updates.

If you checkmark Notify me when this report part is updated on the server option, then the report Builder automatically asks you for updates.

Review Report Part Updates

Please select the report Parts that you want to update. Here, we are selecting all the report parts in SSRS.

Checkmark all or few Report Parts and update

As you can see from the below screenshot, Employee table updated with the new report part ( No yearly Income Column)

Let me show you the SSRS report parts preview

SSRS Report Parts Preview