O'Reilly logo

Microsoft® SQL Server® 2008 Reporting Services Step by Step by Stacia Misner

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required