Summary

Grouping and Sorting is a separate reporting tool from a simple query tool. Matrix and Table both have the capability to perform multiple levels of grouping. Matrix provides the ability to group across multiple columns as well as rows. Although List can only contain a single grouping, nesting a list creates the same effect as multiple grouping.

SSRS provided multiple ways to allow for sorting. Data regions can sort data statically, as well as provide an interactive sort . Using query parameters and expressions, it is also possible to make Dynamic SQL to do sorting within the database.

Scope is another critical aspect of sorting and grouping. In most cases, scope is handled effortlessly by default. In the cases in which scope is dynamic, SSRS provides an InScope function to check and see if a scope is valid.