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-5
M
LIST_COUNT session option 2-5
Local date and time 3-2, 4-40
Locating data 3-2
Log files
content of 2-12
creating command file from 2-13
displaying current 2-13
Logical line 1-11
Logical tables 3-6, 3-26
LOGICAL_FOLDING layout option
double-byte characters 4-59
using 2-6
Lowercase comparison 3-11
M
M (mask) display descriptor 4-30
Macros, TACL 4-44
Major change in report 2-18
Margins
layout option settings for 4-1
wider than device 2-7
Masks
conditional printing of text 4-46
date format 4-44
zero suppression 4-30
MAX function 3-18
Maximum length of line 1-13
MIN function 3-18
Modifiers, display 4-30
Monetary values 4-1, 4-35
Multilevel group aggregates A-7
Multiple
conditions 3-9
line heading 4-18
Multistep queries 3-35, A-7
N
NAME clause 4-13
NAME command 4-13
Named parameters 3-23
Naming items 4-13
NATIONAL CHAR data type
comparison 3-11
NEED clause
description of 4-5
example of 4-7
Nested subqueries 3-32
NEWLINE_CHAR style option 4-18, 4-48
NOHEAD clause 4-16
NOT operator 3-13
NULL predicate 3-9
NULL_DISPLAY style option 4-48
Numbering
lines 4-25
pages 4-5
Numeric values
display descriptors for 4-30
formatting 4-31
justification, left or right 4-29
O
Obey command file
See Command file
OC modifier 4-38
Offset 4-1
Operators
arithmetic 3-22
Boolean 3-7
comparison 3-7
Option variables, Enform A-5
Options, setting and displaying 2-4
OR operator 3-7
Order
arithmetic evaluation 3-22
condition evaluation 3-13
select list 3-16
ORDER BY clause
break groups, relation to 4-14
description of 3-16
row grouping 3-17