Christine Courty

1
Creating Graphs Using Reports Builder 10g

• Christine Courty
• Consultant
• Scandent Solutions, Inc.
• August 11, 2006

2
Agenda

• Build a Simple Report
• Graph Wizard
• Graph Types
• Build a Bar Graph
• XML
• QA

3
Build a Simple Report

• Open Report Builder
• Using Version 10g

4
Build a Simple Report

• Create a new report

5
Build a Simple Report

• Create query Q_1 to get employee info

6
Graph Wizard

• Build default layout using template
• Start the Graph Wizard

7
Graph Wizard

• Also use the wizard to modify an existing graph.
• Called Chart Wizard in Reports 6i fewer
  options.

8
Graph Wizard

• Choose the type of graph...

9
Graph Types

• Bar Graph - Subtypes
• Bar
• Dual-Y Bar
• Split Dual-Y Bar
• Percent
• Stacked Bar
• Dual-Y Stacked Bar
• Split Dual-Y Stacked Bar

10
Graph Types

• Pie Graph - Subtypes
• Pie
• Multiple Pie
• Pie-Bar
• Ring
• Multiple Ring
• Ring-Bar

11
Graph Types

• Line Graph - Subtypes
• Line
• Dual-Y Line
• Split Dual-Y Line
• Percent Line
• Stacked Line
• Dual-Y Stacked Line
• Split Dual-Y Stacked Line

12
Graph Types

• Area Graph - Subtypes
• Area
• Split Dual-Y Area
• Percent Area
• Stacked Area
• Split Dual-Y Stacked Area

13
Graph Types

• Combination Graph - Subtypes
• Combination
• Dual-Y Combination

14
Graph Types

• Scatter/Bubble Graph - Subtypes
• Scatter
• Dual-Y Scatter
• Bubble
• Dual-Y Bubble

15
Graph Types

• Stock Graph - Subtypes
• Hi-Lo-Close
• Hi-Lo-Close with Volume
• Open-Hi-Lo-Close
• Open-Hi-Lo-Close with Volume
• Open-Close Candle
• Open-Close Candle with Volume
• Open-Hi-Lo-Close Candle
• Open-Hi-Lo-Close Candle with Volume

16
Graph Types

• Circular Graph - Subtypes
• Polar
• Radar

17
Graph Types

• Circular Graph - Subtypes
• Polar
• Radar

18
Graph Types

• Pareto Graph - Subtypes
• Pareto

19
Graph Types

• ThreeD Graph - Subtypes
• 3-D Bar
• 3-D Cube
• 3-D Area
• 3-D Ribbon
• 3-D Surface

20
Build a Bar Graph

• Display graph before or after report output?

21
Build a Bar Graph

• Select the column to be displayed along the X
  Axis (bottom/horizontal)

22
Build a Bar Graph

• Employee Name is chosen for the X Axis.

23
Build a Bar Graph

• Choose the Salary column to be displayed along
  the Y Axis.

24
Build a Bar Graph

• Layout Page

25
Build a Bar Graph

• Add titles and a footnote (optional)

26
Build a Bar Graph

• Use the Insert dropdown to select a field from
  the report to include in the title.

27
Build a Bar Graph

• Can modify the title font

28
Build a Bar Graph

• Make modifications to the legend

29
Build a Bar Graph

• Choose the position of the legend

30
Build a Bar Graph

• Modify the background color

31
Build a Bar Graph

• Group Axis Format Page

32
Build a Bar Graph

• Data Axis Format Page

33
Build a Bar Graph

• Reference Lines Dialog Box

34
Build a Bar Graph

• Plot Area Page

35
Build a Bar Graph

• Data Tip Options (Click on Options button)

36
Build a Bar Graph

• Hyperlink Page

37
Build a Bar Graph

• Click Finish the Bar Graph is created.
• Selections saved in file called graph.xml.

38
XML

• To make further modifications, edit the XML.
• Open the property sheet of the graph CT_1.
• Click on the Graph Settings property.

39
XML
Edit the Graph Settings to customize the graph
and graph.xml. It is possible to implement
customizations that would not be possible by
using the Graph Wizard.
40
XML
The default graph settings for a very basic line
graph
ltrwgraph id"CT_2" src"G_ENAME"
groups"EmpName" dataValues"Salary"gt lt!-- lt?xml
version"1.0" ?gt ltGraph version"3.2.0.22"
markerDisplayed"false" graphType"LINE_VERT_ABS"/
gt --gt lt/rwgraphgt
41
XML
More complex graph settings for a line graph
ltrwgraph id"CT_1" src"G_LineName1"
groups"ProjectYear1" series"LineName1"
dataValues"ProjectCost1"gt lt!-- lt?xml
version"1.0" ?gt ltGraph version"3.2.0.22"
markerDisplayed"true" graphicAntialiasing"true"
markerShapeInLegend"true" graphType"LINE_VERT_AB
S"gt ltDataMarker markerSize"30"/gt ltLegendArea
automaticPlacement"AP_NEVER" position"LAP_RIGHT"
/gt ltMarkerText visible"false"/gt ltO1TickLabel
tickLabelSkipMode"TLS_NOSKIP"/gt ltO1Title
text"Year" visible"true"gt ltGraphFont
size"12"/gt lt/O1Titlegt ltPlotArea
fillColor"cccccc" fillTransparent"false"/gt ltSer
iesItems defaultColor""gt ltSeries id"0"
markerShape"MS_DIAMOND" color"69cd9b"/gt ltSeri
es id"8" markerShape"MS_TRIANGLE_UP"
color"0"/gt lt/SeriesItemsgt ltTitle text"10-Year
CapEx Graph" visible"true"/gt ltY1Axisgt ltViewFormat
numberType"NUMTYPE_CURRENCY" currencySymbol""
scaleFactor"SCALEFACTOR_NONE" numberTypeUsed"tru
e" currencySymbolUsed"true" scaleFactorUsed"true
"/gt lt/Y1Axisgt ltY1MajorTick lineColor"666666"/gt lt
Y2MajorTick lineColor"666666"/gt lt/Graphgt --gt lt/
rwgraphgt
42
QA
Questions? For more information OTN Oracle
Reports Technical FAQ on Graphs http//www.oracle
.com/technology/products/reports/htdocs/faq/Graph_
FAQ_with_style.html OTN Oracle Reports Technical
Note on DTD for Customizing Graphs in Oracle
Reports http//www.oracle.com/technology/products
/reports/htdocs/getstart/whitepapers/graphdtd/grap
h_dtd_technote_2.html OTN Graph Legend
Components http//213.35.38.54/otn_hosted_doc/jde
veloper/905/f1_bi_graph/f1_bi_graph/f1_graph_legen
d_components.html