As I mentioned previously , I’ll try to run through all the nice new features of Reporting Services 2008 R2. We’ve covered the Sparklines and the Shared Data sets , so lets now focus on something called Report Parts.
The image above shows a folder on Report Manager where Report Parts have been published. You get a nice "puzzle" icon with it.
Now this really is a feature that will drive ad-hoc reporting amongst business users. Its easy to set up , and it makes report creation laughably easy , almost too easy. Basically you now have the ability to publish each part of your report as an individual object. A person using report builder can then browse what report parts are available on a report server and then simply drag them onto his report. Nothing needs to be set up or configured, it will create any related objects for you , like data sources or data sets. You simply "drag and run". All formatting is maintained as well. Firstly, however, somebody has to create the Report Parts iteself. This isn’t too difficult.
Once you’ve created a report in Report Builder 2 , you can select the "Publish Report Parts" option from the main drop down menu at the top left. In Visual Studio , you would have to click in Report – "Publish Report Parts". In the report that I’ve created below , each guage , table and chart will be published as an individual report part.