To generate spreadsheet output:
rwrun
or Reports
Server clients (rwcgi
, rwclient
, rwservlet
),
with DESFORMAT
=SPREADSHEET
.
For example, to use rwservlet
to generate Microsoft
Excel output from the paper layout of your report, enter a command that includes
the following:
http://hostname:port/reports/rwservlet?report=report_name
+server=server_name+userid=db_connect_string+destype=file
+desformat=spreadsheet+desname=C:\temp\myexcel_output.htm
Notes:
It is not possible to generate spreadsheet output directly from Reports Builder.
Microsoft Office 2000/2002/2003 supports Hypertext Markup Language (HTML) as a native file format. Spreadsheet output relies on producing HTML output, which can be understood by Excel as a file with valid Excel 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.