Progress
Report Builder
Tutorial


Newsport Database

The Newsport database is a demonstration database that contains customer and order information for the All Around Sports company. Table 1–2 describes the tables in the Newsport database.

Table 1–2: Tables in the Newsport Database
Table
Contents
Customer
Customer information, such as customer name, address, phone number, and credit limit.
Invoice
Accounting information, such as order number, invoice number, and billing total.
Item
Inventory information, such as item name, catalog description, and price.
Local–Default
Information for working with international customers, such as country name, currency, and postal format.
Order
Order form information, such as order date, shipping date, postal carrier, and warehouse from which the order was shipped.
Order–Line
Information relevant to a request for one item in a particular order, such as item number, quantity, price, and associated order number.
Ref–Call
Customer call information, such as call number and reason for call.
Salesrep
Sales representative information, such as name, region, and monthly quota.
Shipping–Charges
Shipping charges information, such as the warehouse region, destination state, and price per pound for shipping goods from the regions to specific states.
State
State information, such as state name, abbreviation, and region.

With this database, All Around Sports can take, process, bill, and ship orders. It also allows the company to keep inventory information up to date. All the sample reports in this tutorial use the Newsport database and will not provide the same output with another database. However, you can apply the skills and concepts that you learn in the sample reports to create reports for other databases.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095