Uniquely Named Report Object Variables
A report object variable in CDM can represent one data cell in a worksheet, but it must have a unique name.
You can define the unique name, but the syntax of the variable is always the same.
The following table describes the report object variables that can be uniquely named.
Variable |
Variable Type |
Example |
Description |
|---|---|---|---|
|
Source |
|
This variable tags an item to be displayed in another Excel or Word report object. The contents of the two cells immediately to the right of this variable code determine the unique name for the variable and the value. |
|
Destination |
|
This variable calls an item that has been tagged by the |
|
Rule |
|
A report can contain data from different sources. This variable is useful in applying rules to validate data in a report. The contents of the two cells immediately to the right of this variable code determine the unique name for the variable and the value. |
For example, you can have a variable with the following values:
- Code:
##S - Unique Name: fsyear
- Value: 2009
When the variable is applied elsewhere in the report, it has a specific syntax of ##D<fsyear>. In this example, ##D<fsyear> is replaced with the value 2009 when the report is generated.
Important: Creating source variables that reference destination variables causes refresh issues, which results in unexpected values. For more information, see the CDM Administration Guide.