Report Object Variables

Uniquely named report object variables are used in CDM to reference information between report objects in the same report, or in the same report object. They can be created on an ad hoc basis by users or the administrator. You can also create global report object variables that will reference information between report objects in different reports.

You can use the following types of report object variables:

• Predefined
  A variable that is applied for a specific purpose. No unique name is required for this variable.
• Uniquely named
  A variable with a unique name that is created and does not occur elsewhere in the report.

In either case, the ## symbol set is used to denote the beginning of a variable, except when creating a print area named range variable.

Tip: You can refresh your objects in advance each time a variable or query update occurs using the Use Advanced Refresh option (this will not work for interactive queries). This option must be enabled in the CDM.config file. It can then be selected for use in a report's properties.

Tip: See the following articles for more:

• Naming Conventions for Report Object Variables
• Predefined Report Object Variables
• Uniquely Named Report Object Variables
• Use Report Object Variables to Set a Display Range
• Use a Report Object Variable to Create a Data Reference
• Use a Report Object Variable to Create a Named Range in an Excel Object
• Create a Print Area Named Range Variable in an Excel Object
• Create Multiple Named Ranges in an Excel Object Print Area
• Use a Report Object Variable to Convert a Range in an Excel Object into an Image
• Use a Report Object Variable for Note Numbering
• Use a Report Object Variable to Apply Validation Rules in an Excel Object
• Use a Report Object Variable to Create a Table of Contents
• Create a Section Header Variable in a Word Object