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

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

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