Oracle Reports is a tool for developing reports against data stored in an
Oracle database
Oracle Database (commonly referred to as Oracle DBMS, Oracle Autonomous Database, or simply as Oracle) is a multi-model database management system produced and marketed by Oracle Corporation.
It is a database commonly used for running online t ...
. Oracle Reports consists of Oracle Reports Developer (a component of the
Oracle Developer Suite
Oracle Developer Suite is a suite of development tools released by the Oracle Corporation. The principal components were initially Oracle Forms and Oracle Reports and the suite was later expanded to include Oracle Designer and JDeveloper amongst ...
) and Oracle Application Server Reports Services (a component of the
Oracle Application Server
The Oracle Application Server 10g (the "g" stands for ''grid'') (short Oracle AS), consists of an integrated, standards-based software platform. It forms part of Oracle Corporation's Fusion Middleware technology stack. The heart of Oracle Applic ...
).
Output formats
The report output can be delivered directly to a printer or saved in the following formats:
HTML
The HyperText Markup Language or HTML is the standard markup language for documents designed to be displayed in a web browser. It can be assisted by technologies such as Cascading Style Sheets (CSS) and scripting languages such as JavaScri ...
,
RTF
RTF may refer to:
Organisations
* African Union Regional Task Force, the military operation of the RCI-LRA, 2011–2018.
* Radiodiffusion-Télévision Française, a broadcaster in France, 1949–1964
* Russian Tennis Federation, the national gover ...
,
PDF
Portable Document Format (PDF), standardized as ISO 32000, is a file format developed by Adobe in 1992 to present documents, including text formatting and images, in a manner independent of application software, hardware, and operating systems. ...
,
XML
Extensible Markup Language (XML) is a markup language and file format for storing, transmitting, and reconstructing arbitrary data. It defines a set of rules for encoding documents in a format that is both human-readable and machine-readable. T ...
,
Microsoft Excel
Microsoft Excel is a spreadsheet developed by Microsoft for Microsoft Windows, Windows, macOS, Android (operating system), Android and iOS. It features calculation or computation capabilities, graphing tools, pivot tables, and a macro (comp ...
History
Oracle RPT
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
* Character based report writing tool.
* The software was purchased by Oracle from a third party
Oracle Reports 1
* New GUI mode IDE
* Major rewrite
Oracle Reports 2.0
Oracle Reports 2.5
Release April 1995.
New Object Navigator.
New Toolbars.
New Menus.
Still no undos.
More stable IDE.
Oracle Reports 6i
New features added in 6i:
*
WebDB integration
* XML Output
* HTML Parameter Form Extensions
* SQL Access to the Reports Server Queue
* EXEC_SQL Integration
Oracle Reports 9i
New features added in 9i:
* XML report definition
* Query types: XML,
JDBC
Java Database Connectivity (JDBC) is an application programming interface (API) for the programming language Java, which defines how a client may access a database. It is a Java-based data access technology used for Java database connectivity. I ...
, Oracle9i
OLAP
Online analytical processing, or OLAP (), is an approach to answer multi-dimensional analytical (MDA) queries swiftly in computing. OLAP is part of the broader category of business intelligence, which also encompasses relational databases, repor ...
,
text file
A text file (sometimes spelled textfile; an old alternative name is flatfile) is a kind of computer file that is structured as a sequence of lines of electronic text. A text file exists stored as data within a computer file system. In operating ...
s
* 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
New features added in 10g:
[{{cite web, url=http://www.oracle.com/technology/products/reports/10gr2/10_1_2_new_features.pdf, archive-url=https://web.archive.org/web/20060925202428/http://www.oracle.com/technology/products/reports/10gr2/10_1_2_new_features.pdf, url-status=dead, archive-date=2006-09-25, title=Oracle Reports 10g Release 2 (10.1.2) New Features]
* New output format spreadsheet, output to Microsoft Excel.
* Extended HTML formatting customisation
* Compliant to HTML 4.01 and XML 1.1 standards...
References
External links
Oracle ReportsOracle Reports FAQRPT Conversion to PL/SQL Stored Procedures
Oracle software
Reporting software