Skip to main content

Page Reference Variables

You can use page reference variables to identify and reference a report object in a generated report in CDM. Page start and page end variables are used to signify the starting page and last page of the same report object.

A page reference number is defined in the Page Reference Variable field of report object properties. After defining a variable for the page reference and saving the changes, you can reference the report object anywhere within the report. When you reference a report object, you have the following options:

  • Reference the start of a page
    You can reference the start of a page by using the ##PRS variable followed by the variable name specified in the report object properties (##PRS<varname>). During report generation, this variable is resolved to the starting page number of the specified report object.
  • Reference the end of a page
    You can reference the end of a page by using the ##PRE variable followed by the variable name specified in the report object properties (##PRE<varname>). During report generation, this variable is resolved to the ending page number of the specified report object.

For referencing the start of a page. You have a report object, called Obj1, that is five pages long. You want to reference the starting page of Obj1 in a report object that exists elsewhere in the report. You first navigate to Obj1 and define a page reference variable (pagerefvar1) in the report object properties. You then use the ##PRS variable to reference the page start of the report object in Obj5 using the following syntax: ##PRS<pagerefvar1>. After report generation, Obj1 is compiled to start at page 10. When you navigate to Obj5 after the report is generated, the variable specified has been converted to the number 10.

For referencing the end of a page. Taking into consideration the example for referencing the start of a page, you want to now reference the end page of Obj1 in Obj5, which exists elsewhere in the report. After ensuring that Obj1 has a page reference variable, you first navigate to Obj5 and uses the following variable to reference the end page of the report object: ##PRE<pagerefvar2>. After report generation, Obj1 is compiled to start at page 10. Because Obj1 is five pages long, Obj1 ends at page 15. When you navigate to Obj5 after the report is generated, the variable specified has been converted to the number 15.

Use a Page Reference Variable to Reference the Start of a Page

You can use a page reference variable to reference the start of a page in an Excel or Word object in CDM.

  1. Open the report that you want to work with.
  2. Open and check out the report object for which you want to reference a start page.
  3. Click the Section View Mode icon in the status bar.
  4. Enter a variable in the Page Reference Variable field of the report object properties.
  5. Using the syntax ##PRS<varname>, place the variable in the work area of the report object where you want the start page to be set.
  6. Save your changes in the report object.
  7. Click the Default View Mode icon in the status bar.
  8. Save your changes to the report and check in the report object.

Use a Page Reference Variable to Reference the End of a Page

You can use a page reference variable to reference the end of a page in an Excel or Word object in CDM. Ensure that you have created a page reference variable that references the starting page.

  1. Open the report that you want to work with.
  2. Open and check out the report object for which you want to reference an end page.
  3. Click the Section View Mode icon in the status bar.
  4. Enter a variable in the Page Reference Variable field of the report object properties.
  5. Using the syntax ##PRE<varname>, place the variable in the work area of the report object where you want the end page to be set.
  6. Save your changes in the report object.
  7. Click the Default View Mode icon in the status bar.
  8. Save your changes to the report and check in the report object.

Was this article helpful?

We're sorry to hear that.