Chapter 14. Grouping, Sorting, Aggregating Data, and Working with Scope

Grouping and sorting functionality provides some of the key motivators for purchasing reporting tools. Although every enterprise database management system (DBMS) can group and sort data, reports presented to business users usually have multiple levels of grouping inside of them, not to mention lots of pretty pictures, complex layouts, and graphs. A simple query tool is inadequate for this task. This chapter discusses grouping and sorting and when it is appropriate to do it in SSRS versus the ...

Get Microsoft® SQL Server™ 2008 Reporting Services Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.