Oracle使用Report 报表工具建立图形化报表.doc

Creating a Graph Using the Graph Wizard Purpose In this tutorial, you learn how to create and customize a graph using the Graph Wizard. Time to Complete Approximately one hour Topics This tutorial covers the following topics: Overview Scenario Prerequisites Defining the Data Model Creating a Graph in the Paper Layout View Customizing a Graph Generating Report Output to a PDF File Summary Related information Viewing Screenshots Note: Alternatively, you can place the cursor over each individual icon in the following steps to load and view only the screenshot associated with that step. ? Overview You can add a variety of charts and graphs, including true three-dimensional graphs, to a report using the Graph Wizard. In this tutorial, you will create a report that contains just a graph ? a pictorial representation of data. You will begin by defining the data model for the graph, and then creating the graph in the Paper Layout view of the Report Editor using the Graph Wizard. You will learn how to customize the look and feel of the graph and finally, generate PDF output for your report. ? ? Scenario The graph that you create in this tutorial displays the average price and quantity for orders that are ready for shipment. The graph is based on the Order Entry data model. Prerequisites Before starting this tutorial, you should: 1. Have access to or have installed Oracle Reports Developer . 2. Have access to or installed the sample schema. This tutorial uses the OE schema included in the Oracle10g database. 3. Download reportsOBE.zip and unzip into your working directory. Defining the Data Model Before you can create a graph, you need to identify the data that the graph will display. Begin by creating a new report. 1. If it is not already open, start Oracle Reports by clicking the Reports Builder icon on your desktop. The welcome screen displays. Select the option Build a new report manually. Click OK. If Reports Builder is already open, c