Specifying options for Express data

As part of the configuration of Oracle Reports and Express Server, you can optionally use a file called xrpdsprefs.ora to specify information for the following options:

Location of the xrpdsprefs.ora file

The xrpdsprefs.ora file is not installed with Oracle Reports. If you want to use the file to set options, then you can create the file and store it in the same directory as the xrpdsxxx.jar file (where xxx is a version number), which is the ORACLE_HOME/reports/jlib directory on Windows and the ORACLE_HOME/jlib directory on UNIX. The JAR file exists on the machines for both Reports Builder and Reports Server. You should edit the settings as you want them in the xrpdsprefs.ora file on the Reports Builder machine, then copy the file to the Reports Server machine.

Example xrpdsprefs.ora file

The xrpdsprefs.ora file is a plain text file in which the pound sign (#) specifies a comment. The following example shows a fragment of an example xrpdsprefs.ora file.

#    Hierarchy properties
options.hierarchy.indent.count=3
options.hierarchy.indent.string="+"
#     SNAPI properties
options.snapi.FetchAlloc=5M
# Connection file properties
options.ecf.version=632

See also

Using the Express data source

About configuring the Express data source