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

Index
HP NonStop SQL/MP Report Writer Guide—527213-001
Index-3
E
Defaults (continued)
report
description of 4-45
example of 1-5
spacing 4-8
subtotal label 4-51
subvolume 2-1, 2-3
system 2-1, 2-2, 2-3
volume 2-2, 2-3, 2-18
Descriptor
See Display descriptors
Detail alias names 4-49
DETAIL command 4-12
Detail line
description of 1-6
expressions in 3-22
items in 4-11
naming items 4-13
Digit display 4-31
Display descriptors
I display descriptors 4-30
using 4-30
with double-byte characters 4-62
Display formats
specifications for 4-30
table of 4-28
Display modifiers 4-30
Display template 4-30
Distinct rows
in count 3-17
selecting 3-20
Dollar sign insertion 4-34
Double spacing 4-9
Double-byte characters, printing
considerations for 4-58
E
Editing
commands 2-11
report 2-19
ELSE clause 4-46
Enform language A-1/A-7
ENV command 2-2
Environment, session 2-1
European date-time format 4-42
European decimal character 4-35
Evaluation of expression, arithmetic 3-22
Exclamation point command 1-4
EXECUTE command 3-24
EXISTS predicate 3-9
EXPLAIN command 3-24
Explicit correlation name
example of 3-30
using 3-31
Exponentiation 3-22
Expressions
calculating report values with 3-21
detail line 3-23
evaluation 3-13, 3-22
IF/THEN/ELSE 4-46
F
F display descriptor
using 4-31
zero suppression 4-35
FC command 4-55
Field filler characters 4-1, 4-38
Field size 4-17
File
See Command file
File, defining report in 2-15
Fitting lines on a page 4-5, 4-20
Fixed-point display 4-30
FL modifier 4-38
Folding a line 2-6, 4-59
Footings, break 1-7, 4-22
Formatted report 1-7
Formatting clauses, summary of 1-12
Formatting commands
canceling 2-11