Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).

Reporting Services 2008 R2 Report Parts

Reporting Services 2008 R2 has many new great features that I’ve written about lately (Data Bars and Indicators).  Today I wanted to tell you a little about another nice add called Report Parts.  Report Parts allow you the developer to create an object (graphs, charts, tables, etc…) and then your power users that actually develop reports in Report Builder 3.0 to use those objects in the reports they develop. 

As the developer when you want to publish a Report part to the server.  You will use the menu options Report->Publish Report Parts.  Report Parts can be deployed from Report Builder also.

 

The object is stored on the server and can be picked up inside of Report Builder while developing.

 

Inside Report Builder a power user can browse the Report Part Gallery to find the Report Part needed for their report.  This looks very similar to the clip art browser in Word.

 

Another great thing about Report Parts is when you the developer makes a change to the object all the power user has to do is check for updates on it and the Report Builder will automatically update the object.

 

Comments

No comments.

Leave a Comment

Please register or log in to leave a comment.