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.

vA 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.

vIf 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.

148Query for iSeries Use V5R2

Page 160
Image 160
IBM SC41-5210-04 manual Defining output to the printer in Query for iSeries reports, Integer, Decimal Numeric