Report Properties Dialog Box, Variables (Report Builder 3.0)
Select Variables on the Report Properties dialog box to add custom variables to your report. A variable is processed one time when you run the report and can be referenced throughout the report. Because the variable is calculated only one time, each reference to the variable will always use the same value.
Options
Add
Click to add a variable to the list.Delete
Click to delete the selected variable from the list.Up arrow
Click to move the selected variable in the list.Down arrow
Click to move the selected variable down in the listName
Type a case-sensitive name that begins with a letter and has no spaces. The name can include letters, numbers, or underscores (_).Value
Type a value for the variable or click the Expression (fx) button to write an expression.To include a reference to a variable from an expression, use Visual Basic collection syntax. For example, the following expression specifies a report variable named LastUpdate: =Variables!LastUpdate.Value.