Tutorial for Designer/2000
Lesson 11, page 4
- The following figure provides a closer look at the created report. We will now create a chart that will let us compare the distribution of students in each major. For this, select the Chart Wizard by clicking on the icon with the tiny bar graphs as indicated by the arrow in Figure 11.26.
Figure 11.26: Selecting the Chart Wizard
- You should see the Welcome to the Chart Wizard window. Click Next. (See Figure 11.27)
Figure 11.27: The Welcome to the Chart Wizard Window
- You will now be prompted to enter a chart title, select a chart type and a chart subtype. Type in "Distribution of Students by Majors" in the box for the title. Select Pie as the type of chart and Depth as the Chart Subtype. (See Figure 11.28)
Figure 11.28: Selecting a Chart type and subtype and providing a title for the Chart
- You will now have to select a field for the X-axis. Select Major and click on the right arrow. (See Figure 11.29)
Figure 11.29: Selecting a field for the X axis
- Now select CountStudIdPerMajor as the field for the Y-axis and click on the right arrow. (See Figure 11.30)
Figure 11.30: Selecting a field for the Y axis
- You will now have to select a chart placement for the chart in the report. Let us assume that we would like the chart to be placed at the end of the report. Select at the end of the report and click Next. (See Figure 11.31)
Figure 11.31: Selecting an appropriate chart placement for the chart in the report
- You will now see the Congratulations window. Click on Next. (See Figure 11.32)
Figure 11.32: The Congratulations Window for successfully creating the chart
- Your chart should now look like Figure 11.33.
Figure 11.33: The newly created chart
- See Figure 11.34 to get a view of your report with the chart at the end of it.
Figure 11.34: The report with the chart at the end of it
- You can now save your report by selecting the diskette icon from the toolbar of the report or by selecting File Save as SRSrpt. Oracle will save your report in the Bin folder under Orawin 95 as a .rdf.
- You can also print your report by selecting File Print.
In this lesson you have learned how to:
- Create a simple Data Model using the Report Editor
- Create "Breaks" in the Data Model
- Generate reports based on the created Data Model using the Report Wizard
- Create simple charts using the Chart Wizard
Page 1, Page 2, Page 3, Page 4 / Back to the tutorial index.
About the Book
©1999 Prentice-Hall, Inc., A division of Pearson Education, Upper Saddle River, New Jersey 07458 Legal Statement
Comments should be directed to firstname.lastname@example.org