HP 3000 Manuals HP 3000 Manuals
Example Printouts
Your five reports should look like the following illustrations.
Run (1)
No restrictions on the report execution file DIRECTRS. A copy of this
file is held in file SOL3DIR1.BRWONLNE.ITF3000.
_________________________________________________________________________________
| |
| Report: Customer Details Report: Tutorial Lesson 4 Date: 04/20/92|
| ------- ----- |
| |
| Report requested by: DAVE at: 16:22 |
| -------------------- --- |
| |
| This report prints order details for selected customers in all Sales Areas|
| in June, followed by the total sales for all Sales Areas in June. |
| |
| Customers were selected for this report depending upon the values you |
| gave for the parameters shown below. Note: If CUSTOMER-NO is blank, all |
| customers are selected. |
| |
| Parameter Value (if any) |
| --------- -------------- |
| |
| CUSTOMER-NO |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 2 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: EASTERN |
| -------------------------------- |
| |
| Customer: FOURTH ESTATE MAGAZINES Number: 000004 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-004 A00002 $12.50 1 $12.50 |
| |
| Sales for Customer: FOURTH ESTATE MAGAZINES is: $12.50 |
| ---------------- |
| |
| Sales for SELECTED Customers in EASTERN is: $12.50 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 1 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: NORTHERN |
| -------------------------------- |
| |
| Customer: 7-UP NOVELTIES Number: 000007 |
| --------- ------- |
| |
| ******************** NO ORDERS FOR THIS CUSTOMER ******************** |
| |
| Customer: EIGHT-BALL CUES INC Number: 000008 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-011 A00004 $15.25 63 $960.75 |
| ORD-012 A00008 $0.95 2 $1.90 |
| ORD-013 A00003 $1.25 1 $1.25 |
| ORD-014 A00002 $12.50 6 $75.00 |
| |
| Sales for Customer: EIGHT-BALL CUES INC is: $1,038.90 |
| ---------------- |
| |
| Sales for SELECTED Customers in NORTHERN is: $1,038.90 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 1 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: SOUTHERN |
| -------------------------------- |
| |
| Customer: SECOND GOODS INC. Number: 000002 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-002 A00005 $17.45 5 $87.25 |
| ORD-008 A00007 $1.75 25 $43.75 |
| ORD-010 A00003 $1.25 3 $3.75 |
| |
| Sales for Customer: SECOND GOODS INC. is: $136.55 |
| ---------------- |
| |
| Customer: FIFTH AVENUE FASHIONS Number: 000005 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-005 A00001 $0.75 15 $11.25 |
| ORD-006 A00005 $17.45 2 $34.90 |
| |
| Sales for Customer: FIFTH AVENUE FASHIONS is: $46.15 |
| ---------------- |
| |
| Sales for SELECTED Customers in SOUTHERN is: $182.70 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 1 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: WESTERN |
| -------------------------------- |
| |
| Customer: FIRST REALTY INC. Number: 000001 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-001 A00003 $1.25 10 $12.50 |
| ORD-009 A00001 $0.75 10 $7.50 |
| |
| Sales for Customer: FIRST REALTY INC. is: $20.00 |
| ---------------- |
| |
| Customer: THIRD-FLOOR DESIGN INC Number: 000003 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-003 A00010 $1.85 10 $18.50 |
| ORD-007 A00006 $25.00 11 $275.00 |
| |
| Sales for Customer: THIRD-FLOOR DESIGN INC is: $293.50 |
| ---------------- |
| |
| Customer: SIX-GUN SALOONS INC Number: 000006 |
| --------- ------- |
| |
| ******************** NO ORDERS FOR THIS CUSTOMER ******************** |
| |
| Sales for SELECTED Customers in WESTERN is: $313.50 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 2 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| ================ |
| Total for SELECTED Customers in All Sales Areas is: $1,547.60 |
| --------------------------------------------------- ================ |
| |
_________________________________________________________________________________
Run (2)
Report execution file DIRECTRS, run with the parameter CUSTOMER-NO >
"000002". A copy of this file is held in file SOL3DIR2.BRWONLNE.ITF3000.
_________________________________________________________________________________
| |
| Report: Customer Details Report: Tutorial Lesson 4 Date: 04/20/92|
| ------- ----- |
| |
| Report requested by: DAVE at: 16:23 |
| -------------------- --- |
| |
| This report prints order details for selected customers in all Sales Areas|
| in June, followed by the total sales for all Sales Areas in June. |
| Customers were selected for this report depending upon the values you |
| gave for the parameters shown below. Note: If CUSTOMER-NO is blank, all |
| customers are selected. |
| |
| Parameter Value (if any) |
| --------- -------------- |
| |
| CUSTOMER-NO &daklt; "000002" |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 2 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: EASTERN |
| -------------------------------- |
| |
| Customer: FOURTH ESTATE MAGAZINES Number: 000004 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-004 A00002 $12.50 1 $12.50 |
| |
| Sales for Customer: FOURTH ESTATE MAGAZINES is: $12.50 |
| ---------------- |
| |
| Sales for SELECTED Customers in EASTERN is: $12.50 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 1 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: NORTHERN |
| -------------------------------- |
| |
| Customer: 7-UP NOVELTIES Number: 000007 |
| --------- ------- |
| |
| ******************** NO ORDERS FOR THIS CUSTOMER ******************** |
| |
| Customer: EIGHT-BALL CUES INC Number: 000008 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-011 A00004 $15.25 63 $960.75 |
| ORD-012 A00008 $0.95 2 $1.90 |
| ORD-013 A00003 $1.25 1 $1.25 |
| ORD-014 A00002 $12.50 6 $75.00 |
| |
| Sales for Customer: EIGHT-BALL CUES INC is: $1,038.90 |
| ---------------- |
| |
| Sales for SELECTED Customers in NORTHERN is: $1,038.90 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 1 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: SOUTHERN |
| -------------------------------- |
| |
| Customer: FIFTH AVENUE FASHIONS Number: 000005 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-005 A00001 $0.75 15 $11.25 |
| ORD-006 A00005 $17.45 2 $34.90 |
| |
| Sales for Customer: FIFTH AVENUE FASHIONS is: $46.15 |
| ---------------- |
| |
| Sales for SELECTED Customers in SOUTHERN is: $46.15 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 1 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: WESTERN |
| -------------------------------- |
| |
| Customer: THIRD-FLOOR DESIGN INC Number: 000003 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-003 A00010 $1.85 10 $18.50 |
| ORD-007 A00006 $25.00 11 $275.00 |
| |
| Sales for Customer: THIRD-FLOOR DESIGN INC is: $293.50 |
| ---------------- |
| |
| Customer: SIX-GUN SALOONS INC Number: 000006 |
| --------- ------- |
| |
| ******************** NO ORDERS FOR THIS CUSTOMER ******************** |
| |
| Sales for SELECTED Customers in WESTERN is: $293.50 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 2 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| ================ |
| Total for SELECTED Customers in All Sales Areas is: $1,391.05 |
| --------------------------------------------------- ================ |
| |
_________________________________________________________________________________
Run (3)
Report execution file SALESMAN run with parameter AREA = "WESTERN". No
restriction on the customers reported. A copy of this file is held in
file SOL3SMN1.BRWONLNE.ITF3000.
_________________________________________________________________________________
| |
| Report: Customer Details Report: Tutorial Lesson 4 Date: 04/20/92|
| ------- ----- |
| |
| Report requested by: DAVE at: 16:30 |
| -------------------- --- |
| |
| This report prints the orders for selected customers in Area WESTERN |
| in June, followed by the total sales in June for that Sales Area. |
| Customers were selected for this report depending upon the values you |
| gave for the parameters shown below. Note: If CUSTOMER-NO is blank, all |
| customers are selected. |
| |
| Parameter Value (if any) |
| --------- -------------- |
| |
| CUSTOMER-NO |
| AREA "WESTERN" |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 2 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: WESTERN |
| -------------------------------- |
| |
| Customer: FIRST REALTY INC. Number: 000001 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-001 A00003 $1.25 10 $12.50 |
| ORD-009 A00001 $0.75 10 $7.50 |
| |
| Sales for Customer: FIRST REALTY INC. is: $20.00 |
| ---------------- |
| |
| Customer: THIRD-FLOOR DESIGN INC Number: 000003 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-003 A00010 $1.85 10 $18.50 |
| ORD-007 A00006 $25.00 11 $275.00 |
| |
| Sales for Customer: THIRD-FLOOR DESIGN INC is: $293.50 |
| ---------------- |
| |
| Customer: SIX-GUN SALOONS INC Number: 000006 |
| --------- ------- |
| |
| ******************** NO ORDERS FOR THIS CUSTOMER ******************** |
| |
| Sales for SELECTED Customers in WESTERN is: $313.50 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
Run (4)
Report execution file SALESMAN run with parameter AREA = "WESTERN" and
parameter CUSTOMER-NO > "000002". No restriction on the customers
reported. A copy of this file is held in file SOL3SMN2.BRWONLNE.ITF3000.
_________________________________________________________________________________
| |
| Report: Customer Details Report: Tutorial Lesson 4 Date: 04/20/92|
| ------- ----- |
| |
| Report requested by: DAVE at: 16:34 |
| -------------------- --- |
| |
| This report prints the orders for selected customers in Area WESTERN |
| in June, followed by the total sales in June for that Sales Area. |
| Customers were selected for this report depending upon the values you |
| gave for the parameters shown below. Note: If CUSTOMER-NO is blank, all |
| customers are selected. |
| |
| Parameter Value (if any) |
| --------- -------------- |
| |
| CUSTOMER-No &daklt; "000002" |
| AREA "WESTERN" |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 2 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: WESTERN |
| -------------------------------- |
| |
| Customer: THIRD-FLOOR DESIGN INC Number: 000003 |
| --------- ------- |
| |
| Order No. Product No. Price Quantity Total for Order |
| --------- ----------- ----- -------- --------------- |
| |
| ORD-003 A00010 $1.85 10 $18.50 |
| ORD-007 A00006 $25.00 11 $275.00 |
| |
| Sales for Customer: THIRD-FLOOR DESIGN INC is: $293.50 |
| ---------------- |
| |
| Customer: SIX-GUN SALOONS INC Number: 000006 |
| --------- ------- |
| |
| ******************** NO ORDERS FOR THIS CUSTOMER ******************** |
| |
| Sales for SELECTED Customers in WESTERN is: $293.50 |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________
Run (5)
Report execution file SALESMAN run with parameter AREA = "WESTERN" and
parameter CUSTOMER-NO = "000006". Note that SUBSET ONLY is printed in
the totals line for the sales area. This shows the use of the When zero
print text field on the Numeric Item Edits screen.
_________________________________________________________________________________
| |
| Report: Customer Details Report: Tutorial Lesson 4 Date: 04/20/92|
| ------- ----- |
| |
| Report requested by: DAVE at: 16:35 |
| -------------------- --- |
| |
| This report prints the orders for selected customers in Area WESTERN |
| in June, followed by the total sales in June for that Sales Area. |
| Customers were selected for this report depending upon the values you |
| gave for the parameters shown below. Note: If CUSTOMER-NO is blank, all |
| customers are selected. |
| |
| Parameter Value (if any) |
| --------- -------------- |
| |
| CUSTOMER-NO "000006" |
| AREA "WESTERN" |
| |
_________________________________________________________________________________
_________________________________________________________________________________
| |
| Page: 2 Customer Details Report: 3 Date: 04/20/92|
| ----- -------------------------- ----- |
| |
| Customer Details for Sales Area: WESTERN |
| -------------------------------- |
| |
| Customer: SIX-GUN SALOONS INC Number: 000006 |
| --------- ------- |
| |
| ******************** NO ORDERS FOR THIS CUSTOMER ******************** |
| |
| Sales for SELECTED Customers in WESTERN is: !!SUBSET ONLY!! |
| ------------------------------- --- ================ |
| |
_________________________________________________________________________________