I've got an article titled "Reporting at the Top" over at Simple-Talk that was just published.
This is the article abstract:Often, when developing reports in Reporting Services (SSRS), one has to mix summary information with the details. In Reporting Services, It is not difficult to provide flexible grouping and to display the detail records in a drill-down on-demand method. It is more difficult to combine custom ranking and aggregations on filtered table groups in table based reports. David Leibowitz shows you how to define a flexible report for ranking purposes that allows you to modify the common “Top 100” style report to a “Top X” version that can represent users with a variety of groupings. He also provides an example of a workaround to provide a custom grouping total for the Top items and jazzes it up with some visual indicators.
Check it out here:
http://www.simple-talk.com/sql/sql-server-2005/reporting-at-the-top/