Use Report Object Variables to Set a Display Range

You can use report object variables in an Excel object in CDM to set a display range so that only specific information (rows or columns) is displayed while other information is excluded when the report is generated.

The following figure illustrates a display range that points from the ##RS variable to the ##RE variable.

To define the display range:

1. Open the report that you want to work with.
2. Open and check out the Excel object that you want to edit.
3. Click the Section View Mode icon in the status bar.
4. Navigate to the range in the Excel object that you want displayed in your generated report.
5. In a cell immediately to the upper left of the range, type ##RS.
6. In a cell immediately to the lower right of the range, type ##RE.
7. Save your changes.
8. Click the Default View Mode icon in the status bar.
9. Save your changes to the report and check in the Excel object.