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 list

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