Recent News
|
InnPlanner 2010 Released
New faster database engine, more customization features, weekly tariffs, full multi-user work support and much more... | |
InnPlanner 2010 RC1
InnPlanner 2010 Release Candidate 1 is ready for downloading and testing. You can download it from the "Downloads" section. |
|
|
Hotel Software Documentation
Table Style Editor
Introduction
Table Style Editor is an easy-to-use tool that allows you to customize
the appearance of records in tables. Tables can be used in the following ways:
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 - in 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, which 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 record fields, a number of special columns
are also available:
- RECORD ICON - In this column an icon indicating the record type is
displayed. The icon can be modified in the form properties in the Form Editor;
- RECORD TITLE - This column contains the header of the record. One
of the record's fields is used as its header. This column is very useful
when displaying 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 in the Record
menu the Title Field option;
- FILES COUNT - This column contains the number of
attachments for the record;
- LINKS COUNT - This column contains the number of
links to other records for the record;
- FOUND IN STRING - This column contains the part of the text, in
which the search string was found. See
the Find Records
section for more information;
- RECORD FOLDER - The column contains the name of the folder that
contains the current 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 - the 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 - uncheck this option 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 - turn off this checkbox 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 (record) in the table;
- Selection Back/Fore Color - color of the back/foreground for the
selection of current record;
- Gradient - tick this checkbox to fill the record gradient when
selected.
Table Grid Options
- Draw Grid - untick the checkbox to hide the grid of the table;
- Grid Color - click this button to change the grid color;
- 3D Grid Style - check this option to apply the 3D grid style.
Sort and Group Tab
- Sort records by - this element is used to specify the fields, by
which the table records will be sorted;
- Group 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, 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 on the Summary button to the right of the field by which
records are being grouped, you can create displaying of 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 records in the group (see
figure above).
See Also:
Queries
Folders
|
|
|
|
Today"s Poll
What software do use for your inn/b&b/hotel/etc?
|
About