You can generate a report to delimited output using either of the following methods:
To generate delimited output from Reports Builder:
In the Object Navigator, select or open the report, then click in the toolbar to
run the report.
To preview your delimited report output in a spreadsheet, choose FilePreview
Format
Delimited
or
FilePreview Format
DelimitedData
(for large volume reports).
To save your delimited report output to a file, choose FileGenerate to File
Delimited
or File
Generate to
File
DelimitedData
(for large volume reports).
In the Delimited Output dialog box or DelimitedData Output dialog box, choose from the list or type the delimiter that will separate the cells in your report output.
If you want to use formatting options, choose from the list or type a Date Format Mask or a Number Format Mask.
If you want to use a cell wrapper, choose from the list or type the cell wrapper that will be placed around the cell data in your report output.
Click OK.
To generate delimited output from the command line:
rwcgi
, rwclient
,
rwservlet
) or rwrun
, with DESFORMAT
=DELIMITED
or DELIMITEDDATA
. http://hostname:port/reports/rwservlet?report=report_name
+server=server_name+userid=db_connect_string+destype=cache
+desformat=delimited+mimetype=application/vnd.ms-excel
You can open your delimited output file (.csv
) to display it automatically
in Microsoft Excel. Or, you can import the output file into an existing Excel
worksheet.
When generating a report to delimited output, only data (as defined by the report Data Model), no layout information, is output to Microsoft Excel. To generate report output that preserves the report layout information in Excel output, see About spreadsheet output.
Report distribution
does not support Delimited output format. You cannot specify DELIMITED
as an output format in a distribution XML file or in the Distribution dialog
box.
Report bursting does not support Delimited or DelimitedData output format
Running and dispatching a report from the user interface
Running a report from the command line
Running a report using a command file
Running a report to a remote Reports Server
Generating HTML or HTMLCSS output
Distributing a report to multiple destinations
Copyright © 1984, 2005, Oracle. All rights reserved.