HP 3000 Manuals HP 3000 Manuals
Special Cases
This section provides some examples for special uses of Report Layout
features.
Example: Using alternate lines
Instead of NO_VALUE item edits, you can specify another line in the
detail lineset with a phrase to be used when the item has no value.
Note, however, that the two lines need complementary suppress line
conditions.
The following Customer Order Report has an open join on the orders table.
If a customer has no orders, detail line 2 prints:
**Customer has no orders**
The suppress line condition (line 2) for this is:
NOT (Order-no = NO_VALUE)
In the case of orders from a customer, the suppress line condition for
line 1 is:
Order-no = NO_VALUE
The Define Lines screen for this report looks like this:
![[]](../../pic3k/M011795/FFN983c50.gif)
Example: Bucketing reports
Suppose you want to consolidate several reports into one. In order to do
that, you need to rearrange some of the numeric data from one table from
a vertical orientation to a horizontal orientation.
The report below is an example of bucketing, in which numeric data has
been rearranged.
____________________________________________________________________________________
| |
| |
| Report: SALESREP 11/11/86 Page 1 |
| |
| Area Sales Report by Product |
| ____________________________ |
| |
| Product Line: 60 |
| |
| Product EAST NORTH WEST SOUTH |
| ------- ---------- ---------- ---------- ---------|
| 47392A 352.00 9912.75 45.00 2233.50|
| 14326A 7586.24 789.00 3346.80 24570.00|
| 47392X 4050.00 0.00 4050.00 8100.00|
| 78532J 3650.00 500.00 3650.00 0.00|
| ---------- ---------- --------- ---------|
| |
| Total for product line 15638.24 11201.75 11091.80 34903.50 |
| |
| |
| Product Line: 70 |
| |
| Product EAST NORTH WEST SOUTH |
| ------- ---------- ---------- ---------- ---------|
| 47392A 598.00 50.00 243.95 352.87|
| 14326A 3246.90 100.00 33.15 33.99|
| 47392X 4050.98 2435.60 5690.35 220.00|
| 78532J 9900.10 436.96 445.82 3970.00|
| ---------- ---------- --------- ---------|
| |
| Total for product line 17795.98 3022.56 6413.27 4576.86 |
| |
____________________________________________________________________________________
In order to do this using the sample database TOYDB, you can define four
required table calculated items as listed below:
SALES-EAST IF sales-area = "EAST" THEN quantity * price ELSE 0
SALES-NORTH IF sales-area = "NORTH" THEN quantity * price ELSE 0
SALES-WEST IF sales-area = "WEST" THEN quantity * price ELSE 0
SALES-SOUTH IF sales-area = "SOUTH" THEN quantity * price ELSE 0
On the Define Lines screen below, the break footing on product-number is
defined. This line is used to print the bucketed data. Note that the
report has no detail lines.
![[]](../../pic3k/M011795/FFN1003c50.gif)
Example: Reports for pre-printed forms
HP ALLBASE/BRW lets you set up a report to print on pre-printed forms,
provided you specify the correct positioning of items on the report
layout. Follow the steps below to set up a report for a pre-printed
form:
1. Set up a template report with columns and row numbers which count
across and down the layout, as shown on the next page.
2. Print the template on the pre-printed form paper.
3. Correlate the positions on the form with those on the report
template to determine text and item positioning.
4. Compose the report layout based on the findings in step 3.
In the example on the next page, a mailing address labels report has been
created. The screen shows the resulting lines and positioned item.
![[]](../../pic3k/M011795/FFN1013c50.gif)
_______________________________________________________________________________________
| |
| |
| 10 45678901234567890123456789012345678901234567890123456789012345678901234567890|
| 2 2|
| 3 CUSTOMER-NO: ___________ CUSTOMER-NAME: ____________________ 3|
| 4 4|
| 5 ADDRESS: ____________________ 5|
| 6 ____________________ 6|
| 7 ____________________ 7|
| 8 __ ___________ 8|
| 9 9|
| 20 45678901234567890123456789012345678901234567890123456789012345678901234567890|
| 1 1|
| 2 2|
| 3 CUSTOMER-NO: ___________ CUSTOMER-NAME: ____________________ 3|
| 4 4|
| 5 ADDRESS: ____________________ 5|
| 6 ____________________ 6|
| 7 ____________________ 7|
| 8 __ ___________ 8|
| 9 9|
| 30 45678901234567890123456789012345678901234567890123456789012345678901234567890|
| 1 1|
| 2 2|
| 3 CUSTOMER-NO: ___________ CUSTOMER-NAME: ____________________ 3|
| 4 4|
| 5 ADDRESS: ____________________ 5|
| 6 ____________________ 6|
| 7 ____________________ 7|
| 8 __ ___________ 8|
| 9 9|
| 40 45678901234567890123456789012345678901234567890123456789012345678901234567890|
| 1 1|
| 2 2|
| |
_______________________________________________________________________________________
Example: Voiding unused check forms
The report shown on the next page and the following series of screens
illustrate how to void unused check forms with HP ALLBASE/BRW. The check
report, shown below, has two alternate footings, which print the check
stub (grey areas). The first footing is a page footing. The second
footing is a break footing on vendor.
The Define Breaks screen below shows the break footing as positioned
absolutely in the same position as the page footing. When the break
footing occurs, no page footing is printed on that page. If a break
continues over more than one page, the page footing is printed.
![[]](../../pic3k/M011795/FFN1033c50.gif)
![[]](../../pic3k/M011795/FFN1043c50.gif)
Sample voided check form
The following two Define Lines screens show the page footing lineset and
the break footing lineset. The page footing prints text which voids the
check stub. The break footing prints the actual check amount.
![[]](../../pic3k/M011795/FFN1053c50.gif)
![[]](../../pic3k/M011795/FFN1063c50.gif)
Example: Using horizontal pages
You can set the number of horizontal pages for each physical page. HP
ALLBASE/BRW will then print a series of horizontal pages on one physical
page. You set the number of horizontal pages from a field on the Define
Report screen, labeled "Number of Horizontal Pages".
For example, if you want to print address labels, and the address label
paper is set up so that the labels are three abreast, you can set the
number of horizontal pages to 3.
The labels start printing at the left-hand corner of the page and
continue down the page to the physical end of the page. At the end of
the page, no page eject occurs. Instead, the second column of addresses
starts at the top of the same sheet in the center column. Addresses
print down the center column until the end of the page. The next
addresses start at the top of the page in the right-hand column. At the
bottom of the third column, the paper ejects and the next set of labels
starts at the top of the left-hand column of the next sheet.
Note that HP ALLBASE/BRW considers each label to be one report - only the
manner of printing changes. The default is one horizontal page, or one
page per sheet.
The number of horizontal pages multiplied by (*) the page width cannot
exceed the maximum physical page width of 300 characters.