DATASHEET

Oracle Reports

Oracle Application Server Reports Services &
Oracle Reports Developer

OracleAS Reports Services, the flexible and powerful solution for Web and paper publishing, enables you to publish any data in any format, anywhere. OracleAS Reports Services is part of OracleAS.

Any Data
In modern IT environments, data is generated by multiple sources in various formats. Ideally, publishing this data should be fast and easy, without requiring multiple, convoluted steps to manipulate and consolidate it into a single format.

Oracle Reports accommodates a variety of possible data sources:

SQL (Oracle Database)
PL/SQL (Ref-Cursor)
Express (for backward compatibility)
Oracle OLAP

XML (both file-based and online via HTTP, HTTPS, or FTP)

JDBC

Text files

Additionally, you can add your own, custom data source by leveraging the Pluggable Data Source (PDS) API of Oracle Reports. This is a documented Java API that allows you to create native access mechanisms for data formats that are unique to your business. Developers are unlimited in the number of queries they may use, and may link queries of different types together. They can also use parameters to restrict the results.

Any Format
Modern data publishing requires flexibility in the presentation of data. On one hand, you need boardroom-quality, paper-oriented reports for either printing or rendering in online-presentable formats, such as PDF, HTML or HTMLCSS. On the other hand, you have real Web reporting where the data is part of a Web page that is designed to fit in the overall concept of your corporate Web site.

Both areas of publishing are possible with Oracle Reports. Paper Layout enables you to design high-fidelity, boardroom -uality reports and either print them or create files in various formats (e.g. RTF, HTML/HTMLCSS, PDF) for presentation online. Web Source enables you to "inject" dynamic content into standard Java Server Pages to create "real" Web pages. Additionally, the Paper Layout can be stored in XML format within the JSP file. This way, you have one file that can be used for both Web and paper publishing.

A "real" Web page
created with Oracle Reports using the JSP-based Web source technology

You can also use Oracle Reports for generating data interchange formats, such as delimited or XML. This way a single report can be used to provide three vital parts of modern data publishing:

seamlessly integrated, dynamic content for your Web site

high-fidelity paper reports for printing

data in XML format for Business-2-Business applications

Oracle Reports - PDF1.4 support
Multibyte support, Font-embedding/-subsetting, Compression, Accessibility
( enlarge picture)

Anywhere
Having information where YOU need it is a basic requirement ofmodern data publishing. Providing published data online is only one way to go. Oracle Reports has powerful distribution mechanisms to make sure you get only the data you really need wherever you want it.

The bursting feature of Oracle Reports enables you to create multiple personalized reports out of a single report model. For example, you can create an employee report for all your departments and send an email with a PDF-attachment containing the report to each manager. Each attachment would contain only the relevant department information for the particular manager. All these reports could be created in a single pass and distributed by email to each manager.

Oracle Reports provides a powerful destination infrastructure that allows you to publish your output to any source you want. Out of the box, Oracle Reports ships with the support for a variety of destinations:

File

Printer

Cache (for direct output in the browser)

E-Mail

OraclePortal

FTP

WebDAV

By leveraging the Pluggable Destination API, a Java based interface, you can create your own destination drivers and thereby extend the functionality of this feature.

KEY FEATURES

Design Time

Declarative, wizard-driven design environmen

Open HTML documents to add dynamic report content.

WYSIWYG editor for Paper Layout

Instant preview for paper and Web layouts

Built-in JSP engine for instant preview

Design Time Integration

Migration-Tool for Portal Reports

Java Importer to generate wrapper PL/SQL-Packages for Java classes.

Oracle JDeveloper integration for development and debugging of Reports JSPs

Oracle SCM Integration for Source Control

Data Sources

Unlimited number of queries

Supplied with the product

SQL

PL/SQL

Express

Oracle OLAP NEW in 10g (9.0.4)

XML

JDBC

Text File

Open Java API for adding additional data sources

Full support for parameterized queries

Paper Layout

Unlimited, Frame-based layouts

Conditional Formatting

Bursting

Save the report definition in RDF, JSP, or XML format

Multiple output formats

PDF

RTF

HTML (CSS)

Delimited

XML

Postscript

PCL

Web Source

Java Server Pages based

Shares data model with paper layout

HTML can come from any Web authoring tool

Graphing

50+ different graphs available

Java based

Distribution

Default destinations

Cache

File

Printer

E-Mail ( SMTP-based)

Oracle AS Portal

FTP NEW in 10g (9.0.4)

WebDAV NEW in 10g (9.0.4)

Use open, Java based API to create your own destination

Distribution file in XML-format

Server Infrastructure

100% Java

Peer-level Clustering

Scheduling

Extendable through Pluggable Engines, Pluggable Notifications, Pluggable Security, and Pluggable Cache manager

Standalone and In-Process mode

Reports Web Service NEW in 10g (9.0.4)

Oracle Workflow Integration NEW in 10g (9.0.4)

Central Management NEW in 10g (9.0.4)

Support for headless servers on UNIX NEW in 10g (9.0.4)

APIs

(Java) Plugin APIs

data source

Engine

Security

Notification

Destination

Cache Management

(PL/SQL) Database

Event Driven Publishing API

Security

Single Sign-On for report and data source authentication

Fine-grained Access Control for application authentication (User/Server/Printer/Calendar)

Top of Page | Copyright and Corporate Info