SQL/MX Report Writer Guide

Using MXCI and the Report Writer
HP NonStop SQL/MX Report Writer Guide—527194-002
2-5
Setting and Displaying Options
Setting and Displaying Options
There are three basic commands for working with options: SET, RESET, and SHOW.
There are two types of options you can use to customize your reports:
•
Layout options, such as line spacing and margin settings, control the appearance
of a report on the screen or printed page.
•
Style options, such as the decimal character and underline character, control the
appearance of items in a report.
Figure 2-1 illustrates setting and displaying options.
Figure 2-1. Setting and Displaying Options
VST0202.vsd
>> SET STYLE DATE_FORMAT 'DA, MA Y4',
+> SUBTOTAL_LABEL "Subtotal", UNDERLINE_CHAR '=';
>> SHOW LAYOUT RIGHT_MARGIN ;
RIGHT_MARGIN 80
>> SHOW STYLE *;
-------------------------------------------------------------------------
Current STYLE Option Values
-------------------------------------------------------------------------
DATE_FORMAT DA, MA Y4
DECIMAL_POINT
.
HEADINGS ON
NEWLINE_CHAR /
NULL_DISPLAY ?
OVERFLOW_CHAR *
ROWCOUNT ON
SUBTOTAL_LABELSubtotal
TIME_FORMAT HP2:M2:S2
UNDERLINE_CHAR =
VARCHAR_WIDTH 80