SQL/MX Report Writer Guide

Introduction to the NonStop SQL/MX Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
1-13
Print Items and Logical Lines
•
Clauses
•
Style options
•
Layout options
•
Report functions
This subsection provides a summary of the report writer components. For a detailed
description of these components, see the SQL/MX Reference Manual.
Print Items and Logical Lines
Print items identify the items to print in the titles, footings, and detail lines of your report
and are optionally accompanied by formatting instructions. A list of print items defines
a logical line.
A print item is generally one of these:
•
A column identifier
•
A literal
•
An arithmetic expression
•
Any of these clauses: CONCAT, IF/THEN/ELSE, NEED, PAGE, SPACE, SKIP,
and TAB.
(In some clauses, restrictions apply to print items. For specific information about
restrictions, see the descriptions of individual clauses and commands in the
SQL/MX Reference Manual.)
A column identifier identifies one of the columns in the result of a SELECT command
(a column in the select list) or a named column in the detail line.
The column identifier can be:
Column Identifier Description
Column name The name of a column described in the select list.
•
Must be qualified if it is the same as another unqualified name in
the select list (for example, EMPLOYEE.DEPTNUM and
DEPT.DEPTNUM).
•
If only one name is in the select list (for example,
EMPLOYEE.DEPTNUM), you can omit the qualifier.