Oracle_Reports Knowpia

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).

Output formats edit

The report output can be delivered directly to a printer or saved in the following formats: HTML, RTF, PDF, XML, Microsoft Excel

History edit

Oracle RPT edit

Oracle RPT was an early, primitive predecessor to SQL*Report Writer. There was no editor or IDE provided and instead the reports were created by editing text files to control the report output.

SQL*Report Writer edit

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

Oracle Reports 1 edit

New GUI mode IDE
Major rewrite

Oracle Reports 2.0 edit

Oracle Reports 2.5 edit

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

Still no undos.

More stable IDE.

Oracle Reports 6i edit

New features added in 6i:^[1]

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

Oracle Reports 9i edit

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
Integration with BI Beans
Oracle9iAS Portal Report Import
Edit Oracle9iAS Discoverer Worksheet Export.

Oracle Reports 10g edit

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...

References edit

^ "New Features in Oracle Reports Developer and Reports Server 6i" (PDF).
^ "Oracle9i Reports New Features" (PDF). Archived from the original (PDF) on 2006-09-28.
^ "Oracle Reports 10g Release 2 (10.1.2) New Features" (PDF). Archived from the original (PDF) on 2006-09-25.