Oracle Reports

From Wikipedia, the free encyclopedia

This article needs references that appear in reliable third-party publications. Primary sources or sources affiliated with the subject are generally not sufficient for a Wikipedia article. Please add more appropriate citations from reliable sources. (May 2008)

Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer (a component of the Oracle Developer Suite) and Oracle Application Server Reports Services (a component of the Oracle Application Server).

Contents 1 Output formats 2 History 2.1 Oracle RPT 2.2 SQL*ReportWriter 2.3 Oracle Reports 1 2.4 Oracle Reports 2.5 2.5 Oracle Reports 6i 2.6 Oracle Reports 9i 2.7 Oracle Reports 10g 3 References 4 External links

[edit] Output formats

The reports can be delivered directly to a printer or saved in the following formats:

• HTML
• RTF
• PDF
• XML
• Microsoft Excel
• RDF

[edit] History

[edit] Oracle RPT

This is not the same product as Oracle Reports. RPT was an early,jatt primitive predecessor to SQL*ReportWriter.

[edit] SQL*ReportWriter

• Character based report writing tool.
• The software was purchased by Oracle from a third party

[edit] Oracle Reports 1

• New GUI mode IDE
• Major rewrite

[edit] Oracle Reports 2.5

Release April 1995. New Object Navigator. New Toolbars. New Menus.

Still no undos.

[edit] Oracle Reports 6i

New features added in 6i:^[1]

• WebDB integration
• XML Output
• HTML Parameter Form Extensions
• SQL Access to the Reports Server Queue
• EXEC_SQL Integration

[edit] Oracle Reports 9i

New features added in 9i:^[2]

• XML report definition
• Query types: XML, JDBC, Oracle9i OLAP, text files
• Pluggable Data Sources
• Java Importer
• Oracle9i JDeveloper Integration
• Oracle9i SCM Integration
• Graphing
• Oracle9iAS Portal Report Import
• Edit Oracle9iAS Discoverer Worksheet Export.

[edit] Oracle Reports 10g

New features added in 10g:^[3]

• New output format SPREADSHEET, output to Microsoft Excel.
• Extended HTML formatting customisation
• Compliant to HTML 4.01 and XML 1.1 standards

[edit] References

1. ^ "New Features in Oracle Reports Developer and Reports Server 6i". http://www.oracle.com/technology/products/reports/pdf/275638.pdf. 
2. ^ "Oracle9i Reports New Features". http://www.oracle.com/technology/products/reports/htdocs/getstart/presentations/pdf_reports9i_new_features.pdf. 
3. ^ "Oracle Reports 10g Release 2 (10.1.2) New Features". http://www.oracle.com/technology/products/reports/10gr2/10_1_2_new_features.pdf. 

[edit] External links

• Oracle Reports
• Oracle Reports FAQ