SQL/MP Report Writer Guide
Table Of Contents
- What’s New in This Manual
- About This Manual
- 1 Introduction to the NonStop SQL/MP Report Writer
- 2 Using SQLCI and the Report Writer
- 3 Selecting Data for a Report
- 4 Customizing a Report
- Defining the Layout
- Specifying the Items in a Detail Line
- Naming Select List and Detail Line Items
- Organizing Rows Into Break Groups
- Labeling Information
- Formatting Data Values
- Formatting Dates and Times
- Using TACL to Pass Parameters
- Conditional Printing of Items or Line Entries
- Redefining Special Characters
- Calculating Totals
- Calculating Subtotals
- Printing Double-Byte Characters
- A Comparison of the Report Writer and the Enform Language
- Index
Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-55
Calculating Subtotals
•
The OVER clause indicates when a subtotal is to be calculated. If you omit the
OVER clause, the subtotals appear whenever any data value in any currently
defined break column changes. Only one SUBTOTAL command without an OVER
clause is in effect at one time.
•
You can delete all subtotal commands by entering:
S> RESET REPORT SUBTOTAL;
RESET REPORT BREAK also resets subtotals by deleting the specified break
columns. You can change a SUBTOTAL command with the FC command, replace
the command by reentering it with the same OVER specification, or modify the
SUBTOTAL command by using RESET REPORT SUBTOTAL (
column-list).
•
Entering a SUBTOTAL command returns you to the first row of selected output.
•
You should make the display format for the column large enough to accommodate
the subtotal values.
Defining a Subtotal Label
A subtotal label appears in the break column when the subtotal is calculated. In the
report in Figure 4-20
, no subtotal labels appear because the break column SUPPNUM
does not appear in the detail line. When the value of SUPPNUM changes, the subtotal
is calculated but no label appears.
The report in Figure 4-22
summarizes current orders. Subtotals are calculated over
more than one break group.
The default subtotal label is an asterisk (*). You can set a different default label with the
SET STYLE command. For example, the following command sets the label used in
Figure 4-22
:
>> SET STYLE SUBTOTAL_LABEL "* * *";
You can specify from 0 through 255 single-byte characters (or 0 through 177
doublebyte characters) in the label. To turn off subtotal labeling, specify zero
characters as follows:
>> SET STYLE SUBTOTAL_LABEL "";
The label you specify applies to all subtotals. If the label does not fit in the column, the
string is truncated.
The following commands define the report in Figure 4-20
:
>> VOLUME SALES;
>> SELECT * FROM ORDERS O, ODETAIL OD
+> WHERE O.ORDERNUM = OD.ORDERNUM
+> ORDER BY CUSTNUM, OD.ORDERNUM;
S> DETAIL CUSTNUM,
Note. If you are defining a report that contains double-byte characters, see Printing Double-
Byte Characters on page 4-58 for special considerations regarding defining subtotal labels.