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:
|11g New Features and Enhancements||Equivalent 10g Functionality|
Enhancements for existing graph types:
Support for number formatting in the Graph Wizard, and plotting irregular time periods on the time-axis.
Restrictions on plotting time data.
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.dtdis available in the following locations:
In Getting Started with Oracle Reports on the Oracle Technology Network (OTN): on the Oracle Reports page (
http://www.oracle.com/technology/products/reports/index.html), 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.
When you specify a graph title, subtitle, footnote, or axis title in the Graph Wizard, you can insert lexical references (to user parameters, system parameters, and columns) in the text that will display their value at runtime.
In prior releases, the Graph Wizard's Type panel included a 3DEffect check box to allow you to specify whether to display the graph with the appearance of depth. To implement this effect in the current release, you will need to edit your graph XML definition as shown in bold font in the following example for a bar graph:
<rw:graph id="CT_1" src="G_EMPNO" groups="ENAME" dataValues="SAL"> <?xml version="1.0" ?> <Graph version="188.8.131.52" depthAngle="50" depthradius="8" pieDepth="30" pieTilt="20"/> ... --> </rw:graph>
Reports built with previous versions of Oracle Reports containing Oracle Graphics 6i charts will continue to run if the Oracle Graphics 6i runtime is installed on the same computer in a separate
ORACLE_HOME. However, this is not a supported configuration, and Oracle will not fix bugs that result from this configuration.
For most graphing needs, the following primary graph types will provide the best means to represent data:
These are special usage or less common graphs that are associated with particular data types or ways to display unique cases of data:
curved line graph
See Also, Section 39.3, "New Graph Types"
To display the Graph Wizard for paper reports:
In the Paper Layout view, choose Insert > Graph.
In the Paper Layout view, right-click in the main area (canvas region) and choose Graph Wizard.
To display the Graph Wizard for JSP-based Web reports:
In the Web Source view, choose Insert > Graph.
To re-enter the Graph Wizard for an existing graph in paper reports:
In the Paper Layout view, click the graph.
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.
For help on the fields on any tab page of the wizard, click Help at the bottom of the tab page.