COL.HDG

COL.HDG, DISPLAY.NAME

Top  Previous  Next

 

The COL.HDG keyword defines an alternative column heading for reported data. The synonym DISPLAY.NAME may be used.

 

 

Format

 

field COL.HDG text

 

where

 

fieldis the field or expression to which the new column heading is to be applied.

 

textis the new column heading. This must be enclosed in single or double quotes.

 

 

The default column heading for reported data is the display name from the dictionary entry or, for evaluated expressions, the expression. The COL.HDG field qualifier can be used to set an alternative column heading.

 

 

The text may include the control tokens that control how the column heading is displayed. The codes are enclosed in single quotes which implies that a column heading specification that uses the codes must itself be enclosed in double quotes.

 

'L'appearing within text breaks the heading onto a new line at that point. This is equivalent to use of a value mark in a dictionary heading definition.

 

'R'at the start of the heading text right aligns the heading.

 

'X'at the start of the heading text suppresses the dot fillers normally inserted into unused columns of the heading.

 

If both R and X are to be used, they should be enclosed in a single set of quotes.

 

 

Examples

 

LIST INVOICES AMT.DUE COL.HDG "Outstanding" SITE.NAME WITH NO AMT.RECEIVED

 

This command reports records from the INVOICES file where no payment has been recorded. The AMT.DUE field has the column heading set to "Outstanding".

 

 

LIST SALES CUST.NO COL.HDG "Client'L'Number" VALUE COL.HDG "'RX'Value"

 

This command reports records from the SALES file. The heading for the CUST.NO field occupies two lines. The column heading for VALUE is right justified with the normal dot filler suppressed.