Microsoft® SQL Server® 2008 Reporting Services Step by Step

Changing Report Item Properties by Using Expressions

The power of Reporting Services lies in the ability to use expressions to control virtually every property of each report item. You can use expressions to set a fixed value for a property or to change a property’s value dynamically according to conditions at report execution. These conditions can be determined by a value returned in the data, by a user selection, or by the result of a calculation.

Using an Expression to Sort Data

By default, rows in a data region display in the same order that records are returned in the dataset. For large data volumes, you get the best performance when you let the database engine sort records by adding an ORDER BY clause to the query string. You can override ...