Previous Topic

Next Topic

Book Contents

Book Index

Data Display options

There are a number of ways you can change the appearance of the display.

Grid Style

The general appearance of the grid (colors etc) is governed by the grid style. This is specified on Options > Grid Appearance > Style. AQT provides a number of pre-built style, or you can create your own customized style.

You can change the style used on a particular display window with View > Amend Layout (or the Layout toolbar button) and change the Style Sheet.


By default, the Font used for the display is given by Options > Grid Appearance > Font.

If you wish to change the font used for this particular display, use View > Amend Layout.

Column Widths

Columns will expand to the width of the data, up to a maximum width. The maximum width is specified in Options > Grid Appearance > Maximum column width.

You can manually change the width of columns by dragging the column separator (in the column header).

Row Numbers

You can display a Row Number column by selecting View > Row Numbers (or F4), or clicking on the Numbers toolbar item.

You can specify whether row numbers are displayed by default with Options > Display Options > Show Row Numbers.


You can specify whether a Group-by Box is displayed with View > Group-by box (or Ctrl+G), or clicking on the Group toolbar item. The group-by box allows you to group your data by particular columns. This is discussed in Analyse data by grouping columns.

You can specify whether the Group-by box is displayed by default with Options > Grid Appearance > Show group-by box.

Row Height

The height of rows is governed by Options > Grid Appearance > Minimum Row Height. You may wish to increase this if you are using a larger font than the default.

You can display the data with variable row heights; in this case the height of the rows expands to fit the size of the data. You select this with View > Variable Row Height (or Ctrl+H) or the Height toolbar button. You can specify that Variable Row Heights are used by default with Options > Grid Appearance > Variable Row Height.

Options > Grid Appearance > Maximum Row Height specifies the maximum height for the rows.

If you have particularly large column values, see the section Displaying Large Text Values to see how to display and view these.

Fixed-column Splitter

You can Fix columns so that they don't move when the grid is scrolled left / right. Once way of doing this is to have the Fixed-Column Splitter on the grid - this appears on the grid at the left of the column headers. The use of this is discussed in more detail in Using the Grid.

You can display the Fixed-Column Splitter with View > Show fixed-column splitter. You can specify whether this is displayed by default with Options > Grid Appearance > Show fixed-column splitter.

Column Titles

By default, the titles of the columns are the names of the columns in the query. For complex queries, it can be more useful to have the column expression used as the title instead. For example, if the query is:


Then the column titles will be EMPNO and 2. When View > Use column expressions as headers is specified, the column titles will be EMPNO and SALARY+BONUS.

Amending the Layout of the grid

You can get more comprehensive options for the layout of your data by clicking on View > Amend Layout.

Saving the Layout of the grid

Once you have adjusted the layout of the data according to the way you wish to view it, you can save this layout information with View > Save Layout. This is described in more detail in Saving / retrieving the display Layout.