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 books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.