Previous Topic

Next Topic

Book Contents

Book Index

Formatting Data

For more comprehensive data formatting options, from the Data Display window, click on View > Amend Layout or click on the Layout button. This will take you to the Data Layout window. Within this window you can:

Saving / Loading the Display Formatting

Once you have formatted the data in the way you want, you can save the data layout. See Saving / retrieving the display Layout for more on this.

Sort Order

Use this column to specify the columns the display is to be sorted by.

Sorting by multiple columns

You can sort by multiple columns.

When you are sorting by multiple columns, the sequence that they will be sorted by is the order the columns appear in the display. For instance, if you wish to sort by ColumnA, then by ColumnB, you need to have ColumnA appearing before ColumnB in the display.


This specifies the data format AQT uses to display the data in the grid. Note that this determines how the values are displayed - the underlying data value is unchanged.

For character columns, AQT uses a format of General.

For numeric columns, by default AQT will use a format of General. You have the choice of a number of a number of other options:


Display data with thousands separator, currency symbol and with two digits right of the decimal place. Based on the system locale settings.


Display number with thousand separator, at least one digit to the left and two digits to the right of the decimal separator.


This, and the following item, are examples of custom numeric formats. These are described later.



For date and time columns, by default the values are displayed as per Options > Display Format > Format of Date Time columns. The following other formats are available:

Short Date

Display a date/time according to your system's short date format.

Long Date

Display a date/time according to your system's long date format.

Full Date

Display a date/time according to your system's long date format plus the time.


This, and the following item, are examples of custom date formats. These are described later.



Custom Formats

For numeric values and date / time values, you can also use custom-formats, for example

In these:


digit placeholder, Display a digit or nothing


digit placeholder. Display a digit or 0.


decimal digit


thousands separator


percent indicator. When this is specified in the format-string, the value will be multiplied by 100 and the % placed where indicated.


if any of these characters are specified, they will be displayed as is.


display other literal string




day. Can be specified as dd (numeric day), ddd (short day name) or dddd (full day name)


month. Can be specified as M (without leading zero), MM (with leading zero), MMM (short month name) or MMMM (full month name)


year. Can be specified as yy or yyyy


hour. Can be specified as h (without leading 0) or hh (with leading zero)


minute. Can be specified as m or mm.


second. Can be specified as s or ss.