4D Doc Center : Setting column display formats

Home

4D v14.3

Setting column display formats

You can specify display formats for columns that contain numeric, alphanumeric, date, time and picture data.

For example, if you are displaying prices in a column, you can add a numeric format to the Detail cell for the Price field. The $###,##0.00;-$###,##0.00 format places a dollar sign ($) to the left of the number and can display dollar amounts from -$999,999.99 to $999,999.99.

If your report includes Alpha fields such as a telephone number or Social Security number, you can use an Alpha format. If your report displays dates, times or pictures, you can also assign display formats to them.

4D provides different default display formats. However, you can create your own display styles for numeric and alphanumeric formats. For more information about this point, refer to Display formats.

To assign a display format to a numeric, alpha, date, time or picture field:

Right-click on a cell of the column with which you want to associate a style.
The context menu of the editor appears.
Select the desired display format from the Format submenu.
The contents of the submenu vary according to the type of data contained in the column: numeric, alphanumeric, date, time or picture. If the report column contains data that cannot be formatted, the Format command does not appear in the context menu.

The format is entered in the Detail cell. If you have also requested summary calculations for the column, the format specified in the Detail cell will automatically be applied to the summary calculations. The only exception is the “Count” calculation which is always displayed as an integer and does not accept any formatting symbols such as the dollar sign. You can also enter the formats to be applied manually by clicking twice in the cell and entering the elements of the format using the keyboard.

Different formats can be applied to different columns in the report.