Working with Variables

As you learned earlier in this chapter, the location of an expression within a report affects when it is evaluated. In addition, the expression’s location determines how many times it is evaluated. As you switch from page to page in a report, expressions on the requested page are evaluated when you open the page. You can manage the evaluation of expression-based values by using variables.

Variables are a new feature in Reporting Services 2008. You can store an explicit value in a variable, or use an expression that calculates a value at run time. You can scope a variable to a group or to the report. A group variable evaluates when the group instance changes, so it can potentially change even on the same page of a report. ...

Get Microsoft® SQL Server® 2008 Reporting Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.