The All-in-One Database Software Solution

Online Help System

Back to Brilliant Database Web-Site | Write to Support | Help Index

Table Style Editor

Introduction

Table Style Editor is an easy-to-use tool that allows you to customize the appearance of database software records in tables. Tables can be used in the following ways:

When displaying database software records in a folder (use the Folder > View > Appearance... menu command);
When displaying a list of related database software records in the many-to-many relational field (in Form Editor select a needed element and on the Individual Properties tab click Configure Appearance...) ;
When printing a many-to-many relational field (in Report Style Editor select a needed element and on the Individual Properties tab and click Configure Appearance...).

Table Styles examples:

Changing the default color skin:
Displaying a multiline text using different fonts, displaying the contents of an image field in a table:

Table Style Editor Interface

The upper pane consists of three tabs:

Columns - on this tab you can select columns to be displayed and customize their properties (positioning, text font, colors);
Rows and Header - this tab allows you to customize the properties of the table rows (height, style) and of the table header;
Sort and Group - using this tab you can set the order of data sorting and grouping (this tab is available for certain tables only).

In the bottom pane of the window there is a test table that is used as a table style preview.

Columns Tab

The left pane of the Columns tab contains the list of columns available in the table. To add new columns or delete existing ones, click the Add/Remove Columns... button in the upper right part of the window. In addition to the columns representing the data of the database software record fields, a number of special columns are also available:

RECORD ICON - in this column an icon indicating the database software record type is displayed. The icon can be modified in the form properties in Form Editor;
RECORD TITLE - this column contains the header of the database software record. One of the database software record fields is used as its header. This column is very useful when displaying database software records of different types in one table. For example, if one folder contains the list of authors and the list of books, the RECORD TITLE column will contain the titles of the books and the names of the authors. Such header field can be defined by selecting the Title Field option in the Record menu.
FILES COUNT - this column contains the number of attachments for the database software record;
LINKS COUNT - this column contains the number of links to other database software records for the database software record;
FOUND IN STRING - this column contains the part of the text, in which the search string was found. To learn more, see the Find Records section.
RECORD FOLDER - this column contains the name of the folder that contains the current database software record;

The right part of the window can be used to edit the selected column:

Font - the font used in the column;
Text Alignment - text alignment in the column (left, right or center);
Back/Fore color - background color and text color for the column;
Alternative Title - the header title of the selected field. If empty, the field name will be used.
Position - these buttons help you change the position of the column within the table;
Apply to All Columns - click this button to apply the properties of the column (color, font) to all other columns of the table.

Rows and Header Tab

Header Options

Draw Header - clear this check box to hide the table header;
Header Font - defines the font of the header;
Header Back/Fore Color - defines the background color of the header and the font color;
Fit last column - clear this check box if you don't want the last column to be fitted to the table width:

Rows Appearance Options

Row Height - defines the height of a row (database software record) in the table;
Selection Back/Fore Color - color of the back/foreground for the selection of the current database software record;
Gradient - select this check box to fill the database software record gradient when selected.

Table Grid Options

Draw Grid - clear the check box to hide the grid of the table;
Grid Color - click this button to change the grid color;
3D Grid Style - select this check box to apply the 3D grid style.

Sort and Group Tab

Sort database software records by - this element is used to specify the fields, by which the table database software records will be sorted;
Group database software records by - these elements can be used to group data in a table by fields. Grouping is available for the many-to-many relational fields and query results only.

To make sure the grouping works right, database software records are to be sorted by the same fields as the grouping is done by; otherwise, you can receive several groups with the same name.

Using the buttons at the bottom of the window, you can customize the color, font, group header and footer and select whether the groups are to be collapsed by default or not:

By clicking the Summary button to the right of the field by which database software records are being grouped, you can create displaying subtotals for each group using the wizard:

Comments - select the text to be displayed before the calculated value;
Field - select the field, by which the calculation is to be done;
Operation - select what is to be calculated by this field (total, average, max/min value, value count).

The line with the calculated data will appear below all database software records in the group (see the picture above).