Tutorial for Designer/2000
and Developer/2000

Lesson 11

In this lesson you will learn how to create reports based on our existing Student table. Specifically, this will involve:

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

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.

Creating Reports:

  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 Programs->Developer 2000 R2.1->Report Builder (See Figure 11.2)

    Figure 11.2

    Figure 11.2: Logging on to Report Builder

  2. 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

    Figure 11.3: The Welcome to Report Builder window

  3. 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

    Figure 11.4: Window for the Report Editor- Data Model

  4. 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

    Figure 11.5: The SQL icon in the toolbar of the Report Editor

    Figure 11.6

    Figure 11.6: The SQL Query Statement window

  5. 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

    Figure 11.7: The Connect window for connecting to the Database

  6. 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

    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.

Main Page About the Book Student Resources Oracle Resources Instructor Resources Contact Us

1999 Prentice-Hall, Inc., A division of Pearson Education, Upper Saddle River, New Jersey 07458 Legal Statement
Comments should be directed to webmaster@prenhall.com