SQL/MX Report Writer Guide

Using MXCI and the Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
2-10
Entering Report Formatting Commands
Entering Report Formatting Commands
Report formatting commands must be associated with a specific SELECT command.
You can enter these commands only at the select-in-progress prompt (S>).
In Figure 2-5, DETAIL, BREAK ON, and BREAK TITLE are report formatting
commands that refer to the selected data.
Figure 2-4. Relation of Window to Output Line
1000
SET LAYOUT
WINDOW
FIRST_NAME;
4
(FIRST_NAME column moves to left edge of window.)
100JERRY
FIRST_NAME LAST_NAME JOBCODE
HOWARD
SET LAYOUT
WINDOW EMPNUM;
3
EMPNUM FIRST_NAME LAST_NAME
JOBCODE
1000
23 ROGER HOWARD
(EMPNUM column moves to left edge of window.)
SET LAYOUT
WINDOW TAB 15
2
MANAGER
LOCATION
DEPTNAME EMPNUM
FINANCE 23
CHICAGO
23
JERRY
FIRST_NAME
(15th position of output line moves to left edge of window.)
MANAGER LOCATIONDEPTNAMEDEPTNUM EMPNUM
FINANCE
23
CHICAGO
23
Default left edge of
window is TAB 1
1
(Screen Position 64)
(Left margin of 5 print positions is part of output line.)
(First position of output line is at left edge of window.)
VST0207.vsd