From Library or Report Packages on the Home page, select the report package for which you want to change the static variables.
On the Report Center, click the Variables tab , and select the static variable that you want to modify.
Click the number in the In Use column for the variable to see all locations that the variable is being used.
Select the variables that you want to edit, using one of the following options:
To edit a single variable, under Actions, select Edit.
To edit multiple variables at one time, click Ctrl as you select each variable, and then select the button and select Edit.
Modify the Name, Description or Value, and then click OK.
Note:
The change is reflected on the Variables tab. The system opens the Excel file and updates the variable value. It does not recalculate the reference file. is displayed next to any impacted doclet.
From the report center, an is displayed next to the impacted doclet.
In order to clear the impacted indication, you need to recalculate the reference file in Excel.
Select . A message is displayed stating you need to recalculate the reference file in Excel. You must download the impacted Excel file and open it within Excel. Excel recalculates the spreadsheet (typically this is done automatically.) You may also need to execute additional macros.
After you have recalculated, in order to clear this message and next to the doclet impacted, select , . By selecting , it clears the error message as well as next to the impacted reference file.