DESFORMAT
command line keywordDESFORMAT
specifies either the output format
for the report, or the printer definition to use when formatting the report
when DESTYPE=FILE
and DESNAME=filename
.
The executables that can use this keyword are:
rwbuilder |
yes (not recommended; overrides the DESFORMAT
system parameter set in Reports Builder) |
rwrun |
yes |
rwclient |
yes |
rwcgi |
yes |
rwserver |
no |
rwservlet |
yes |
rwconverter |
no |
DESFORMAT=desformat
Values |
Description | ||||||||||||||||||||
|
Any valid destination format not to exceed 1K in length. Reports Builder supports the following destination formats:
|
||||||||||||||||||||
|
Taken from the Initial Value property of the
|
The value(s) for this keyword might be case-sensitive, depending on your operating system.
When DESFORMAT=HTML
or DESFORMAT=HTMLCSS
, spaces
are replaced with
. This default behavior eliminates
alignment issues for number values that are right-aligned. If you do not
want spaces replaced with
in your HTML and HTMLCSS
output, then you must set REPORTS_NO_HTML_SPACE_REPLACE
to YES
. This removes the functionality of the DELIMITER
command line keyword for HTML and HTMLCSS output (DELIMITER
is still valid when DESFORMAT=DELIMITED
).
DESFORMAT=DELIMITED
is not supported in a DST file, which
is specified on the command line with the DESTINATION
keyword
to distribute the report. In this case, Oracle Reports displays an error:
REP-34305: Invalid keyword setting for the destid='DEST1'.
Note: DST files are supported for backward compatibility; the preferred and recommended method of distributing reports is with the Distribution dialog box or using XML, as described in the chapter "Creating Advanced Distributions" in the Oracle Application Server Reports Services Publishing Reports to the Web manual, available on the Oracle Technology Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html).
The DELIMITED
functionality also honors the DELIMITER
,
CELLWRAPPER
, NUMBERFORMATMASK
,
and DATEFORMATMASK
command line
keywords.
When DESFORMAT=DELIMITEDDATA
, the DelimitedData driver runs
off the data model and operates in much the same way as the XML driver.
Since the driver runs off the data model, any formatting changes defined
in the layout are not reflected in the DelimitedData output.
You can set the following column properties to alter column names and exclude columns from the DelimitedData output file:
The XML Tag property can be used to enter a column alias.
The Exclude from XML Output property can be used to exclude the column from the DelimitedData output.
The DELIMITEDDATA
functionality also honors the DELIMITER
,
CELLWRAPPER
, NUMBERFORMATMASK
,
and DATEFORMATMASK
command line
keywords just as DELIMITED
does.
For more information on delimited output, see About delimited output.
When DESFORMAT=SPREADSHEET
, the report output preserves the
formatting defined in the report layout. For detailed information about
how different report objects are generated in a report run to DESFORMAT=SPREADSHEET
,
see About
spreadsheet output.
When you open RTF output generated by Oracle Reports in Microsoft Word 95 for Japanese, you may encounter anomalies in the output, such as dashes not appearing correctly. These issues are specific to Microsoft Word 95 and do not occur in Microsoft Word 97 for Japanese.
Running a report from the command line
Copyright © 1984, 2005, Oracle. All rights reserved.