Use a Report Object Variable to Convert a Range in an Excel Object into an Image

You can use a report object variable in an Excel object in CDM to specify a range, convert it to an image, and have it display in another report object when the report is generated.

1. Open the report that you want to work with.
2. Open and check out the Excel object that has a data range that you want to convert to an image.
3. Click the Section View Mode icon in the status bar.
4. Navigate to the range in the Excel object that you want to convert to an image in your generated report.
5. In a cell immediately to the upper left of the range, type ##IRS.
6. In a cell immediately to the lower right of the range, type ##IRE.

   Important: Ensure that the image variable range is not overlapping or placed inside a display range (that is, the ##RS and ##RE variables) or another image range.

7. Save your changes in the source Excel object.
8. Click the Default View Mode icon in the status bar.
9. Save your changes to the report and check in the Excel object.

You can now use the source object variable to convert the range to an image, and have it display in another report object when the report is generated.