HP 3000 Manuals HP 3000 Manuals
Lesson 3: Quiz 3
1. What are the differences between Suppress Line and Suppress
Lineset?
You suppress a line from the Define Lines screen; one line
only is suppressed. You suppress a lineset from the Define
Breaks screen; an entire lineset is suppressed. See the HP
ALLBASE/BRW Reference Manual for more details.
2. When is a layout calculated item calculated? And when is a table
calculated item calculated?
By default, a layout calculated item is calculated when the
report is formatted. It is calculated once for each detail
line, (that is, once for each record in the final access
table). You can have a layout calculated item calculated
only for a particular lineset by specifying CALC in the
item's ColCalc field on that lineset. See the HP
ALLBASE/BRW Reference Manual for more details.
A table calculated item is calculated when the table in
which is defined is built. The item is calculated once for
each row of the table.
3. Can you sort and break on a layout calculated item? If not, why
not?
No. Because layout calculated items are calculated when
the report is formatted, that is, AFTER the final access
table is built and sorted.
4. Once defined, can you use a layout calculated item in a formula?
Yes. Once created, all calculated items behave exactly
like items from data sets or files and can be printed and
used in formulas.
5. If the ColCalc field for item TURNOVER-MTD on a break footing
shows AVG, what will BRW calculate and print for that item?
The average TURNOVER-MTD in that break. That is, the total
of the values of TURNOVER-MTD in the break divided by the
number of values.
6. What will BRW calculate and print if the ColCalc field in the
above question showed AVG 1,2?
The average of the values of TURNOVER-MTD in the level 1
break. However, the values would be taken from the second
level break, not the detail line, as the source level is 2.