A script-enabled browser is required for this page to function properly.

REPORTS_PATH environment variable

This environment variable specifies the search path for files referenced by Reports Runtime. The directories specified by REPORTS_PATH are searched first, then those specified by ORACLE_PATH. This environment variable is used to locate reports and external objects that you use in your reports, such as PL/SQL libraries, external queries, and external boilerplate. It enables you to create reports that are easily portable across operating systems by preventing the need to hard-code directory paths.

Define REPORTS_PATH in the same fashion you define other environment variables on your operating system, keeping in mind such platform-specific rules as path length, and so on.

In addition to directory paths, you can specify the keyword DB when you define REPORTS_PATH. This instructs Reports Builder to search the database to which you are currently connected.

Suppose you specified the following on a Unix platform:

setenv REPORTS_PATH /home/tkostin/pay:/home/tkostin/receive:DB

Reports Builder will first search the directory /home/tkostin/pay. If it cannot find the file in question, it will search /home/tkostin/receive. If it still cannot find the file, it will search the database to which you connected when you began your Reports Builder session.

Valid Values

Any directory on any drive.

Default

%ORACLE_HOME%\REPORT\DEMO;
%ORACLE_HOME%\REPORT\DEMO\BITMAP;
%ORACLE_HOME%\REPORT\DEMO\REQFILES

 

 

 

Usage notes

Example

REPORTS_PATH=C:\oracle\apps/reports;C:\myfiles

See also

Environment variables