Compare the numbered items on the sample report for a description of each item you, as the sales manager, want to know about.
|
No. |
Report Item |
Your Query Should: |
|---|---|---|
|
&co1. |
Subject |
Search a table for all filled orders. |
|
&co2. |
Title |
Define a logical title. |
|
&co3. |
CUST-ID |
Sort order rows by customer, take control breaks at changes, and print customer ID. |
|
&co4. |
ITM-ID |
Report the items ordered by each customer. |
|
&co5. |
SHIP-QTY |
Tell you how many of each item was shipped. |
|
&co6. |
UNIT-PRICE |
Tell you the price per item. |
|
&co7. |
SHIP-PRICE |
Calculate the total cost of each item shipped to a customer. |
|
&co8. |
TOTAL CUST-ID |
Tell you the total amount ordered by each customer. |
|
&co9. |
AVERAGE ITEM PRICE |
Tell you the average item price for a customer. |
The next sections explain the development of the query that produces the sample report.
|
Copyright © 2014 CA.
All rights reserved.
|
|