Exploring SSRS 2008 R2 Report Builder 3.0 – Report Parts

Report Parts : New in SSRS 2008 R2

There is a good preliminary documentation on building Report Parts in MSDN:
Publishing Report Parts in Report Builder 3.0 – http://msdn.microsoft.com/en-us/library/ee633670%28v=SQL.105%29.aspx

The Good

As per the MSDN documentation, it’s good to know that the following items can now be “reused” across different reports:
• Charts
• Gauges
• Images
• Maps
• Parameters
• Rectangles
• Tables
• Matrices
• Lists

The Not-So-Good-Yet

It seems very limiting to me, though, that Report Parts can only be created/published from Report Builder 3.0. As someone who works almost 100% using BIDS, I think having to switch tools to just be able to publish a report part will definitely affect my report writing momentum. And by switching tools I mean, creating the report in BIDS, deploying to the Report Server, navigating to that site, and then editing that report in Report Builder 3.0. That’s quite a few extra steps …

Also, I would have loved to be able to publish a report header and footer as report parts. Unfortunately the current CTP version does not support it.

Creating your first Report Part

Download document/screenshots: Exploring SSRS 2008 R2 Report Builder 3.0 – Report Parts

For this mini tutorial I am going to assume you have created your report in BIDS 2008.

1. Deploy your report to the report server.

2. Go to that report. Hover over the report name, and click on the down arrow to reveal the contextual dropdown. Select Edit in Report Builder

Report Part - Edit in Report Builder

3. Once Report Builder opens, go to the Report Builder main button (I think it looks like a scroll), and select Publish Report Parts.

Report Part - Publish Report Parts

4. In the Publish Report Parts window, select Review and modify report parts before publishing (unless you really want to publish all report parts with default settings)

Report Part - Publish Report Parts Review

5. In the next window, select which Report Parts you want to publish. Put a description too, makes it easier for your Report Builder users to identify report parts later on.

Report Part - Publish Report Parts Review2

6. When you’re done, click on Publish. Note there is no dialog box notifying you that publishing is done. All you get are the green checkmarks beside the report parts you selected, and the message at the bottom of the Publish Report Parts dialog box saying how many report parts were published, and how many failed.

Report Part - Publish Report Parts Successful

7. If this is the first time you published a Report Part, a new Report Part folder will be created in your report server.

Report Part - Folder

8. Inside the Report Part folder are your published report parts. Note that the icon of the report parts give it away – puzzle pieces! Also note that when you hover over a report part and click on the down arrow, you will reveal the contextual menu for a report part (move, delete, security, manage and download).

Report Part - Folder Contents
That’s it! That’s how you publish your report parts using Report Builder 3.0! Pretty nifty, eh?

Report Part Gallery

Inside the Report Builder 3.0, you will also see the Report Part Gallery tab, which will list all available Report Parts you can add to your report.

Report Part - Gallery

Report Part Updates

It is also important to note that if any report parts get updated, the reports that use that report part will display a notice when opened in Report Builder. It will tell you that the published report part(s) have been updated on the server.

Report Part - Report Part Updated Notice

Once you choose to view changes, you can select which report parts you want to update.

Report Part - Report Part Updated

And once it’s updated, no in-your-face notice again that the update was successful. It’s still just that subtle green checkmark beside the report part you chose to update.

Report Part - Report Part Updated Successful

Download document/screenshots: Exploring SSRS 2008 R2 Report Builder 3.0 – Report Parts

Advertisements

9 comments

  • thanks but i can’t install the SS2008R2, because that is for 64 bit only. how can i get that for 32bit of SS2008?

    Like

  • I from china.thank you very much!

    Like

  • Great. Simple to understand

    Like

  • Hi

    (as of now) You can create report parts and publish them from BIDS! Click the report background and the report menu you have publish. The only thing I still cannot do is to embed them into report using BIDS.

    Regards
    Emil

    Like

  • I’m from Brasil. Thanks you very smoothly!

    Like

  • I’ve been asked to try to present benefits of using BIDS over Report Builder for report creation. Our team was originally given BIDS, and our IT organization replaced it with Report Builder we’re told to limit the harm we can cause as high-end users. Are there valid reasons we might want to argue to keep BIDS over Report Builder using a cube database?

    If so, any insight would be appreciated.

    Like

  • I do not see the “Publish Report Parts” option in the Report menu in BIDS. Emil in their comment (above) said there is. Am I missing something? Do I need to install any components or service pack for that? I am using Microsoft Visual Studio 2008.

    Thanks
    Amarjot

    Like

  • Hi,

    How do I do Ad-hoc reporting in SSRS 2012. And how is it use full to the end user. Basically I wanted to know the roll of developer and business Users. Could you please demonstrate with an example from scratch to and end user perspective.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s