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


In This Chapter

  • Grouping Data on a Report

  • Sorting, Including Interactive User Sorting

  • Scope of an Aggregate Function

  • Level and InScope Functions

Grouping and sorting functionality provides some of the key motivators for purchasing reporting tools. Although every enterprise DBMS has the ability to 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 as well as when it is appropriate to do it in SSRS versus the DBMS. In SSRS, grouping and sorting is available within data regions .



Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net