Skip Headers
Oracle® Fusion Middleware Oracle Reports User's Guide to Building Reports
11g Release 1 (11.1.1)

Part Number B32122-02
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

39.1 About Graphs and Graph Wizards

The Graph Wizard provides an easy way for you to add a wide variety of graphs to both paper-based and JSP-based web reports. Oracle Reports Builder uses the information you specify on each page of the wizard to create an XML definition that describes the graph and renders to resulting look-and-feel of the graph at runtime.

Table 39-1 details the new graphing functionality in Oracle Reports 11g Release 1 (11.1.1), along with the equivalent 10g Release 2 (10.1.2) functionality:

Table 39-1 11g Functionality vs. 10g Functionality

11g New Features and Enhancements Equivalent 10g Functionality

New graph types: New funnel, enhanced pie and curved line graph types allow for more variety in graphing.

  • For funnel graphs, use the Graph Wizard to choose the funnel graph style on the Style panel.

  • For curved line graphs, use the steps in Section, "Adding a graph"to create a simple line graph, then add the following to your graph XML definition:

      <Series id="0" markerType="MT_CURVE_LINE"/>


Enhancements for existing graph types:

Support for number formatting in the Graph Wizard, and plotting irregular time periods on the time-axis.

  • Number formatting support in the Graph Wizard allows you to format the numbers in the graph, independent of the data model.

    For number formatting, use the Graph Wizard (Y Format panel > Format Axis Labels button > Number tab) to format Y-axis numbers.

  • Support for irregular time period enables plotting the time data without restrictions. For more information, see Plotting Irregular Time Periods.

Restrictions on plotting time data.

Scalable Vector Graphic (SVG) image support. SVG provides for high resolution and smaller file size in graph output. Graph image output scales up better without losing resolution.

Support for only PNG, JPG, and GIF output formats.

New Chart Styles: Support for new pre-defined styles in style panel of Graph Wizard.

Support for only a few chart styles.

While the Graph Wizard enables you to create and edit the attribute values and layout of a graph, there are additional attributes that are not exposed through the Graph Wizard. To customize your graph XML definition beyond the scope of the Graph Wizard, you can directly edit the XML in the graph's Graph Settings property (for paper-based reports), or in the Web Source view (for JSP-based Web reports). The full list of attributes available is defined in the DTD file, graph.dtd.


The graph.dtd is available in the following locations:
  • ORACLE_HOME\jlib\bigraphbean.jar

  • In Getting Started with Oracle Reports on the Oracle Technology Network (OTN): on the Oracle Reports page (, click Getting Started to display the Getting Started with Oracle Reports home page. In the list of topic sections on the left, click Index. In the Collateral Type list, choose Documentation and click Search. In the list that is displayed, find Documented Graph DTD.

Usage notes

Primary Graph Types

For most graphing needs, the following primary graph types will provide the best means to represent data:

Secondary Graph Types

These are special usage or less common graphs that are associated with particular data types or ways to display unique cases of data:

See Also, Section 39.3, "New Graph Types"


To display the Graph Wizard for paper reports:

To display the Graph Wizard for JSP-based Web reports:


To re-enter the Graph Wizard for an existing graph in paper reports:

  1. In the Paper Layout view, click the graph.

  2. To display the Graph Wizard in re-entrant mode, do either of the following:

    • Right-click the graph, and choose Graph Wizard.

    • Click the graph, then choose Edit > Settings.

To re-enter the Graph Wizard for an existing graph in JSP-based Web reports:

In the Web Source view, place your cursor anywhere between the <rw:graph> and </rw:graph> tags, then choose Edit > Settings.

Using the Graph Wizard

For help on the fields on any tab page of the wizard, click Help at the bottom of the tab page.

See also

Section, "Adding a graph"

Section, "Editing a graph"

Section, "Adding a graph hyperlink"