Output to Excel IN REPORTS 10g [message #251508] |
Fri, 13 July 2007 20:07 |
siri35in
Messages: 3 Registered: April 2007
|
Junior Member |
|
|
I want to know the steps in generating a report which has no layout model and web layout and the ouptput should open or store in microsoft excel
Thanks in Advance
|
|
|
Re: Output to Excel IN REPORTS 10g [message #254361 is a reply to message #251508] |
Thu, 26 July 2007 10:12 |
linlasj
Messages: 98 Registered: August 2005 Location: Linköping
|
Member |
|
|
Hi,
there is an option in Oracle Reports. See below:
Beginning with 10g Release 2 (10.1.2), Oracle Reports introduces a new output format, which enables you to generate output from paper layout report to HTML files that can be directly opened with Microsoft Excel 2000.
Using the new DESFORMAT=SPREADSHEET, you can: Generate report output to spreadsheet format from existing paper layout reports saved in any format (.rdf, .xml, .jsp), using rwrun or Reports Server clients (rwcgi, rwclient, rwservlet).
Preserve the rich layout formatting such as colors, fonts, conditional formatting, graphs, and images.
Taken from the help from within Oracle Reports.
Br,
Lars
[Updated on: Thu, 26 July 2007 10:13] Report message to a moderator
|
|
|