Export (0) Print
Expand All
Expand Minimize

Series Group Properties Dialog Box, Variables

Select Variables on the Series Group Properties dialog box to add custom variables to your report. A variable is processed when you first run the report and can be referenced throughout the report. Because the variable is calculated only once, each reference to the variable will always use the same value. This can be useful, for example, for capturing values that can change during run time, like a time stamp in a report header. Variable names must be unique throughout the report.

Add

Add a variable to the list.

Delete

Delete the selected variable from 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.

Expression

Type an expression or click the Expression (fx) button to edit the expression. In the Expression pane, labeled Set expression for: Value, make sure that the expression begins with an equal (=) sign.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft