HP 3000 Manuals HP 3000 Manuals
Request the Report
You request the report just as you would request any other report, as
described in Chapter 11 .
Delivery Audit Report
When HPDesk delivery is used, the HP ALLBASE/BRW execution program
(BRWEXEC.PUB.SYS) generates delivery audit trail messages in the
execution statistics that print to your screen. These messages show:
* the delivery service
* the files generated
* the address where the files were sent
* any messages rejected by HP Desk
The example below shows a sample execution statistics record:
____________________________________________________________________________________
| |
| |
| HP lBRW/V <A.02.00> HP36070 (c) Copyright Hewlett-Packard GmbH 1986, 1987|
| 1988 |
| KSAM (A.05.01) |
| PASCAL (A.01.11) |
| |
| Execution File: |
| Parameters: |
| |
| |
| report delivered thru HPDESK |
| - destination switch on level 1 |
| - data file R1234567 |
| - subject: Expense Report 8/87 |
| - sender : Helmut Pohl |
| - from : Helmut Pohl |
| - to : Willi Klenk |
| - cc : Norbert Gronau |
| |
| output file of level 3 footing delivered thru HPDESK |
| - data file R1234568 |
| - subject: Expense Report 8/87 |
| - sender : Helmut Pohl |
| - from : Helmut Pohl |
| - to : Willi Klenk |
| - cc : Norbert Gronau |
| the following addresses have been rejected by HPDESK |
| - to : HP8200/A2 Thomas Heinrich |
| - cc : Acdsdgss |
| |
| Report Info : |
| cpu-sec elapsed-sec |
| time totals for report ============ ============= |
| 3.734 9.413 |
| (1 segment loads for report) |
| (1 segments in report ) |
| (1 segments in memory ) |
| |
| END OF PROGRAM |
| |
| |
____________________________________________________________________________________
In addition to the execution statistics generated by HP ALLBASE/BRW,
usual HPDesk reporting of a successful signon is done to the console and
to the HPDesk Statistics file.
Examples
This section gives the details of some example reports.
Example: Switching destinations
Suppose you have a report that lists the turnover for each sales area.
The customer records are sorted on SALES AREA as the first-level break,
and the total for each area is calculated on the first break footing.
You want to send the area turnover totals to the appropriate area
managers. So you specify a calculated item, AREA-MGR-ADDRESS, with this
formula:
IF SALES-AREA = "EASTERN" THEN "Peter SMITH / HPB200/90"
ELSE IF SALES-AREA = "NORTHERN" THEN "Jane GREY / HPC340/00"
ELSE IF ...
This will return the address of the sales area manager. On the Define
HPDesk Selection screen, you type the item name AREA-MGR-ADDRESS in the
contained in Item field instead of typing a literal address for the
recipient of the report. Select to switch destination on break level 1
(for the sales area). Then, HP BRW-Desk/XL will do the following:
* Split the report at each level 1 break.
* Send the details and break linesets within that break, as a
separate report, to the address taken from the value of
AREA-MGR-ADDRESS on the break footing (that is, the last detail in
the break).
In this way your report will be split and automatically sent to the
appropriate area managers!
When you switch destinations, HP ALLBASE/BRW always takes the value of
the address from the item on the break footing (that is, the last detail
in the break).
The reports shown next represent the results of sending a report with
switched destinations.
Note that for each report, the page number is reset to 1.
___________________________________________________________________________
| |
| |
| Page: 1 Customer Details Report: 1 07/11/89 |
| ----- - --------------------------- -------- |
| |
| Customer Details for Sales Area: EASTERN |
| ----------------------------------------- |
| |
| Customer Number Customer Name Month's Sales|
| --------------- ------------- -------------|
| |
| 100213 BLACK & WHITE 2451.91|
| 100432 SUR 9100.25|
| 100498 C. WINSTON F & S 3654.15|
| |
| Total Sales for Sales Area: EASTERN is: 15206.31|
| --------------------------- --- |
___________________________________________________________________________
___________________________________________________________________________
| |
| |
| Page: 1 Customer Details Report: 1 07/11/89 |
| ----- - --------------------------- -------- |
| |
| Customer Details for Sales Area: NORTHERN |
| ------------------------------------------ |
| |
| Customer Number Customer Name Month's Sales|
| --------------- ------------- -------------|
| |
| 100311 TOOLS EQUIPMENT CORP. 961.87|
| 100580 STANDARD BUILDING MAINT. 545.43|
| |
| Total Sales for Sales Area: NORTHERN is: 1507.30|
| --------------------------- --- |
___________________________________________________________________________
___________________________________________________________________________
| |
| |
| Page: 1 Customer Details Report: 1 07/11/89 |
| ----- - --------------------------- -------- |
| |
| Customer Details for Sales Area: SOUTHERN |
| ------------------------------------------ |
| |
| Customer Number Customer Name Month's Sales|
| --------------- ------------- -------------|
| |
| 100365 LEMWAY INC. 236.54|
| 100888 REGULAR OIL INDUSTRIES 8925.00|
| 100946 BROWN BROTHERS 26455.10|
| |
| Total Sales for Sales Area: SOUTHERN is: 35616.64|
| --------------------------- --- |
___________________________________________________________________________
___________________________________________________________________________
| |
| |
| Page: 1 Customer Details Report: 1 07/11/89 |
| ----- - --------------------------- -------- |
| |
| Customer Details for Sales Area: WESTERN |
| ----------------------------------------- |
| |
| Customer Number Customer Name Month's Sales|
| --------------- ------------- -------------|
| |
| 100114 ACME INDUSTRIES 9580.35|
| 100321 MILLER'S CARS 5147.89|
| 100327 DAILY POST 18400.12|
| 100537 MACHINERY CORP. 31420.75|
| 100568 HIGGIN'S COMPANY 0.00|
| 100827 TU CONSOLIDATED 28600.00|
| 100953 BEVERLY'S SHOP 25423.37|
| |
| Total Sales for Sales Area: WESTERN is: 15206.31|
| --------------------------- --- |
___________________________________________________________________________
Example: Sending an output file
Suppose you want to send the MIS Department a file through HPDesk that
they can download and use in year-end reporting.
To make sure that the MIS department receives the total turnover for all
sales areas, you can send them an output file containing the report
footing (a summary of the total turnover for the year).
* Create an output file for the report footing.
* From the Output File screen, choose other keys and then Define
Delivery.
* Specify the MIS department on the Define HPDesk Delivery screen
for the output file.
* Type Area Turnover Total (Output File) in the Subject field.
* Type TO in the FROM, TO, CC, or BCC field.
* Type the address of the MIS department in the Name/Address field.
* Press Enter.
![[]](../../pic3k/M011795/FFN1553c50.gif)
Note that this will send the output file, not a report, to the MIS
department. The output file cannot be read in the In Tray, however,
HPDesk will automatically deliver the output file.
The output file will have one record, the total turnover:
170902.73
If you wanted the formatted report footing (with headings and so on), you
could print the report in addition and send the paper copy of the report
to the MIS department.