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 Report in SSRS Report Builder article to understand the same.

Report Parts in SSRS 1

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

Report Parts in SSRS 2

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.

Report Parts in SSRS 3

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.

Report Parts in SSRS 4

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.

Report Parts in SSRS 5

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

Report Parts in SSRS 6

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

Report Parts in SSRS 7

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

Report Parts in SSRS 8

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

Report Parts in SSRS 9

Use Report Parts in SSRS Reports

In this example, we will show you how to use the report Parts in SSRS reports. 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 report title as SSRS Report Parts Example, and an Execution time in Page Footer. Apart from that, we also formatted the text

Report Parts in SSRS 10

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

Report Parts in SSRS 11

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.

Report Parts in SSRS 12

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.

Report Parts in SSRS 13

Let me search for the Company

Report Parts in SSRS 14

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

Report Parts in SSRS 15

let me show you the report preview

Report Parts in SSRS 16

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

Report Parts in SSRS 17

And the report preview is:

Report Parts in SSRS 18

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

Report Parts in SSRS 19

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 in SSRS 20

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

Report Parts in SSRS 21

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).

Report Parts in SSRS 22

Update Report Parts in SSRS

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

Report Parts in SSRS 23

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

Report Parts in SSRS 24

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

Report Parts in SSRS 25

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.

Report Parts in SSRS 26

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.

Report Parts in SSRS 27

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

Report Parts in SSRS 28

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

Report Parts in SSRS 29

Let me show you the SSRS report parts report preview

Report Parts in SSRS 30