Filter
Top Products
Original report:
Position to line ..... Shift to column . . .
Line ....+....1....+....2....+....3....+....4....+....5....+..
INTEGER CHAR DECIMAL NUMERIC
000001 1,000,000,001 aaaaaaaaaa 11,111,111.01 11,111,111.01
Report showing wrapping width 15:
Position to line ..... Shift to column . . .
Line ....+....1....+
INTEGER
CHAR
DECIMAL
NUMERIC
000001 1,000,000,001
000002 aaaaaaaaaa
000003 11,111,111.01
000004 11,111,111.01
Alignment for the wrapped fields is uneven in this example, because, although the Column Spacing
value for CHAR is 2, one blank appears after the INTEGER heading and field on the first line, and one
blank appears before the CHAR heading and field on the second line. The Column Spacing value for
DECIMAL is also 2, but both blanks appear after CHAR on the second line and no blanks before
DECIMAL on the third line.
v A summary function caption is used for each wrapped summary line. None of the indent space is
available for these captions. Formatting for these captions may cause additional spacing than specified
for the columns on the line.
v If the wrapping width is too small, Query may truncate or discard information that would otherwise have
appeared in the column (such as a column heading or a count summary), or even drop an entire
column from the report. Values from numeric, date, time or timestamp fields are never partially shown. A
column is dropped from the report rather than present it with no part of the value showing.
Note: Messages about truncated and dropped information appear under a displayed report or if you
press F13 to display the layout. There are no warnings about truncated or dropped information
for a printed report.
Defining output to the printer in Query for iSeries reports
The Define Printer Output display is the first of several printer output definition displays that you can use to
define where, and in what manner, your report is to be printed. This display is used to identify the printer
and some of the print characteristics of the forms (paper) used in the printer, including the length and
width of the forms, the starting and ending print lines on each page, and the line spacing between each
printed record.
148 Query for iSeries Use V5R2