Skip to Main Content
Microsoft® SQL Server 2005 Reporting Services
book

Microsoft® SQL Server 2005 Reporting Services

by Michael Lisin, Jim Joseph
March 2006
Beginner to intermediate content levelBeginner to intermediate
480 pages
11h 17m
English
Sams
Content preview from Microsoft® SQL Server 2005 Reporting Services

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server™ 2008 Reporting Services Unleashed

Microsoft® SQL Server™ 2008 Reporting Services Unleashed

Michael Lisin, Jim Joseph, Amit Goyal

Publisher Resources

ISBN: 0672327996Purchase book