System Variables

System Variables can be used with Parameters and Filters to dynamically determine a comparison Value at report Run Time. An example of this is where a report is run and expected to return data for the current day. In this example a Filter could be set on the report for a Date field and the filter comparison value (or comparator) could be set to the system Variable @DATE@. When the report is run the system variable @DATE@ in the filter comparator will be replaced with the current date.

To select a System Variable when adding a Filter or Parameter click the System Variable button  on the Enter Comparison Value screen.

The Select System Variables screen (shown below) will appear. Select the required System Variable and click OK.

System Variable Format

System Variables must always be prefixed and suffixed with a single @ symbol and must contain no other occurrences of an @ symbol. System Variable names must be unique. System Variables that do not comply to this format will not be recognized by Sage Intelligence.

Listing Available System Variables

To obtain a list of all available system variables (Standard and Custom) select the Sage Intelligence Home object in the Report Manager and from the Tools menu choose Show System Variables. A list of all available System Variables will be displayed.