VERTICALLY

VERTICALLY, VERT

Top  Previous  Next

 

The VERTICALLY display option keyword causes a vertical format report to be produced. The synonym VERT may be used.

 

 

Format

 

VERTICALLY {FMT {"name.format"} {, "data.format"}}

 

where

 

name.formatis an alternative format to be applied to the field heading text.

 

data.formatis a default format to be applied to all data items except those that are defined in the dictionary as being right justified. If data.format is specified but name.format is omitted. the comma is still required.

 

The LIST and SORT commands normally produce a tabular report unless the total width of the data to be reported exceeds that of the display or printer to which it is directed. The VERTICALLY keyword forces a vertical format report regardless of display width. A blank line is produced between each record in the report.

 

The default action of the query processor is to show the field heading text as a left justified 12 character wide column, effectively using a format code of ".L#12". The optional FMT qualifier to the VERTICAL keyword can be used to change this. Note that the default code uses a mask rather than "12.L" which would insert text marks if the name was longer than 12 characters.

 

The FMT qualifier also allows a default format to be applied to all data items included in the report with the exception of those that are defined in the dictionary as being right justified. Thus, for example, a field defined in the dictionary as having a format of "20T" may be good for tabular reports but introduce unwanted line breaks in a vertical report. Use of the data.format element of the FMT qualifier to the VERTICALLY keyword  allows a more appropriate field width to be used. Any display clause element that itself includes a FMT qualifier will override the data.format default for that one field.

 

 

Examples

 

The command

 

LIST INVOICES VALUE CUSTOMER.NAME WITH NO AMT.PAID

 

would produce a display such as that below.

 

LIST INVOICES VALUE CUSTOMER.NAME WITH NO AMT.PAID

Invoice  ...Value  Customer...................

74529    £1712.43  J McTavish

74273      £95.23  County Newspapers

63940     £141.00  R Bryant

3 records listed.

 

Including the VERTICALLY keyword would modify the display format to become

 

LIST INVOICES VERTICALLY VALUE CUSTOMER.NAME WITH NO AMT.PAID

Invoice...74529

Value.....£1712.43

Customer..J McTavish

 

Invoice...74273

Value..... £95.23

Customer..County Newspapers

 

Invoice...63940

Value..... £141.00

Customer..R Bryant

 

3 records listed.

 

Adding a format code to the VERTICALLY keyword reduces the name width as below.

 

LIST INVOICES VERTICALLY FMT "8.L" VALUE CUSTOMER.NAME WITH NO AMT.PAID

Invoice. : 74529

Value... : £1712.43

Customer : J McTavish

 

Invoice. : 74273

Value... :  £95.23

Customer : County Newspapers

 

Invoice. : 63940

Value... :  £141.00

Customer : R Bryant

 

3 records listed.