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