Archive for April, 2010

SQL Server 2008 R2 (SSRS) Free Ebook, Training Kit Out

Ebook

Free ebook from Microsoft Press: Introducing SQL Server 2008 R2

Download from:
http://blogs.msdn.com/microsoft_press/archive/2010/04/14/free-ebook-introducing-microsoft-sql-server-2008-r2.aspx

Training Kit

New updated version of SQL Server 2008 R2 Training Kit is out, and is full of awesome SSRS goodies (hands on labs, tutorials, presentations, and videos).

Download from:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=fffaad6a-0153-4d41-b289-a3ed1d637c0d

VN:F [1.9.22_1171]
Rating: 8.6/10 (11 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

SQL Server 2008 Reporting Services Book Shelf

These two books are great, and they almost never leave my desk. I’ve been reading them nonstop.

Prologika Press. Applied Microsoft SQL Server 2008 Reporting Services by Teo Lachev


Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports by Paul Turley and Robert M. Bruckner


VN:F [1.9.22_1171]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

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

VN:F [1.9.22_1171]
Rating: 8.5/10 (28 votes cast)
VN:F [1.9.22_1171]
Rating: +1 (from 3 votes)
`