SQL/MX Report Writer Guide

Using MXCI and the Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
2-11
Entering Report Formatting Commands
Figure 2-5. Report Formatting Commands
DEPTNUM
FINANCE
EMPNUM LAST_NAME
FINANCE
1000
1500
23
202
208
210
214
209
211
212
HOWARD
CLARK
CRAMER
BARTON
KELLY
CHAPMAN
SCHNEIDER
MITCHELL
Break Title
Break Title
S>
VST0208.vsd
>> SELECT * FROM DEPT, EMPLOYEE
+> WHERE DEPT.DEPTNUM = EMPLOYEE.DEPTNUM
+> ORDER BY DEPT.DEPTNUM, EMPNUM;
S> DETAIL DEPT.DEPTNUM, EMPNUM, LAST_NAME;
S> BREAK ON DEPT.DEPTNUM;
S> BREAK TITLE DEPT.DEPTNUM (DEPTNAME);
S> LIST NEXT 8;