Using GUIDE in SQL Mode › Creating a Sample Query › How to Meet the Need

How to Meet the Need

The following describes tasks to be completed in analyzing and resolving the sample business problem.

Define the need

Create a query that produces a report containing this information:

• The ID of each item shipped.
• How many of each item have been shipped.
• The price of each item.
• The total expected income from each group of items.

Visualize the report

Determine how the report should look.

Identify tables

Find out which tables contain the needed data.

Identify columns

Find out which columns should be referenced to locate the data.

Decide

Whether an existing query or dialog can produce the report. If not, decide whether you want to copy and edit an existing query (or dialog) or write your own. If you want to write your own, decide whether to use GUIDE, CREATE or DRAW.

Begin query creation

Select GUIDE from the Main Menu.

Define report

Access the ONLINE EXECUTION panel for the query created. Select <PF3> FORMAT REPORT and enter specifications. Specifications are saved and become the defaults for the query whenever it is executed.