Tutorial for Designer/2000
In this lesson you will learn how to create reports based on our existing Student table. Specifically, this will involve:
- Using the Data Model Wizard
- Using the Layout Editor to customize our reports
- Creating charts
Our objective will be to create a simple report that will list students along with some student attributes. Students in this report will be categorized by major. As a starting point, let us assume that the STUDENT table has the following rows. (See Figure 11.1).
Figure 11.1: The Student table as viewed in SQL *Plus
You may enter the data shown below using the INSERT statement in SQL*Plus covered earlier in the tutorial (see Lesson 9). For example, the following statement may be used to insert the first row (for the student Diana with Student Id '1113').
SQL> insert into student values ('1113', 'Diana', 'PT', 'F', 'Fall', 1996, 'Marketing', 'Y');
Enter the rest of the data as shown in Figure 11.1.
- In order to create reports, you will need to go to the Reports Builder in Oracle Developer/2000. To do this, go to the Start button and select ProgramsDeveloper 2000 R2.1Report Builder (See Figure 11.2)
Figure 11.2: Logging on to Report Builder
- Immediately, you will see the Welcome to Report Builder Window. Select the radio button for the Build a new report manually and click OK. ( See Figure 11.3)
Figure 11.3: The Welcome to Report Builder window
- Once you click OK, you will see the Report Editor-Data Model window, with a default name for the Data Model. (See Figure 11.4)
Figure 11.4: Window for the Report Editor- Data Model
- The Report Editor is the tool that you will use to create your data model for the report. Click on the SQL icon (See Fig. 11.5) in the toolbar located on the left hand side, and drag and drop it on the palette. Immediately, the SQL Query Statement window will appear. Type in the displayed SQL query to view student information in order of major. (See Figure 11.6)
Figure 11.5: The SQL icon in the toolbar of the Report Editor
Figure 11.6: The SQL Query Statement window
- Once you click OK, Developer/2000 will prompt you to connect to the database. Type in your User Name, Password and Database. (See Figure 11.7).
Figure 11.7: The Connect window for connecting to the Database
- You will now see your data model, where Q_1 stands for the name of the query and G_Major, stands for its associated record group which contains the list of fields that you will be able to view in your report. (See Figure 11.8)
Figure 11.8: The Report Editor with the Data Model
On to page two
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