Difference between revisions of "Table"
(11 intermediate revisions by one other user not shown) | |||
Line 1: | Line 1: | ||
+ | <languages/> | ||
+ | |||
+ | |||
<translate> | <translate> | ||
<!--T:1--> | <!--T:1--> | ||
+ | [[File:mainmenu5.png]] | ||
'''Watch a [[Tables Tutorial|video tutorial]] about tables'''. | '''Watch a [[Tables Tutorial|video tutorial]] about tables'''. | ||
Line 43: | Line 47: | ||
<!--T:13--> | <!--T:13--> | ||
− | |||
− | |||
* [[Object Filters|Filters]] | * [[Object Filters|Filters]] | ||
− | * [[ | + | * [[Conditional Formatting]] |
− | * [[Rows sort]] | + | * [[Rows sort|Rows Sort]] |
+ | * [[Column order|Colum Order]] | ||
+ | * [[Drill Down]] | ||
+ | * [[Total row|Total Row]] | ||
+ | * [[Advanced row filter|Advanced Row Filter]] | ||
+ | * [[Row limit|Row Limit]] | ||
* [[Show Pager]] | * [[Show Pager]] | ||
− | * [[ | + | |
+ | |||
+ | <!--T:20--> | ||
+ | '''Header Properties''' | ||
+ | |||
+ | <!--T:21--> | ||
+ | * [[Header Properties]] | ||
Line 57: | Line 70: | ||
<!--T:15--> | <!--T:15--> | ||
* [[Title bar Properties]] | * [[Title bar Properties]] | ||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
− | |||
Line 70: | Line 76: | ||
<!--T:17--> | <!--T:17--> | ||
− | * [[Alternate row colors]] | + | * [[Frozen Column]] |
− | * [[Border | + | * [[Sequence column|Sequence Column]] |
− | * [[ | + | * [[Alternate row colors|Alternate Row Colors]] |
− | * [[ | + | * [[Hide Border|Show Border]] |
− | * [[ | + | * [[Border color|Border Color]] |
− | * [[Object | + | * [[Grid line color|Grid Line Color]] |
+ | * [[Object positions|Object Positions]] | ||
+ | * [[Object dimensions|Object Dimensions]] | ||
Line 82: | Line 90: | ||
<!--T:19--> | <!--T:19--> | ||
− | + | ''Data Properties'' | |
− | * [[ | + | * [[Selected column]] |
* [[Column name]] | * [[Column name]] | ||
− | * [[Data type]] | + | * [[Data type|Data Type]] |
− | * [[ | + | * [[Column label|Column Label]] |
− | |||
* [[Function]] | * [[Function]] | ||
+ | * [[Column filters]] | ||
+ | * [[Conditional Formatting]] | ||
+ | * [[Delete column|Remove Column]] | ||
+ | * [[Decimal places|Decimal Places]] | ||
+ | * [[Thousand sep.|Thousand Sep.]] | ||
* [[Mask]] | * [[Mask]] | ||
− | * [[ | + | |
− | * [[Column font]] | + | <!--T:22--> |
− | * [[Column font | + | ''Styles'' |
− | * [[Column | + | * [[Column width|Column Width]] |
− | * [[Column font | + | * [[Column font|Column Font]] |
− | * [[Column | + | * [[Column font size|Column Font Size]] |
− | * [[Text alignment]] | + | * [[Column background color|Column Background Color]] |
+ | * [[Column font color|Column Font Color]] | ||
+ | * [[Column font style|Font Style]] | ||
+ | * [[Text alignment|Text Alignment]] | ||
</translate> | </translate> |
Latest revision as of 02:02, 5 October 2022
Watch a video tutorial about tables.
A table is like an object, a collection of columns and rows, that displays data.
You can add to a table object any number of Date, Text, Value and Special columns desired.
By default, the data displayed in the table will be grouped by the Data and Text columns and Value columns will be summarized.
In run-time, tables have navigation buttons where you can change pages by clicking on the arrows or typing the page number directly in the input box, the option to change the number of rows per page and to display information about current and total rows.
For crossed data features in tables, see Cross Table.
Examples
The above example shows a table grouped by the Year and State columns (two first columns) and the summarized amount of Gross Sales and Net Revenue for these groups.
In this other example, using modified Layout Properties, a filtered column that displays only the Pizza Product Profit and an expression to calculate the Pizza Profit percentage participation.
Data Properties
- Filters
- Conditional Formatting
- Rows Sort
- Colum Order
- Drill Down
- Total Row
- Advanced Row Filter
- Row Limit
- Show Pager
Header Properties
Title Bar Properties
Layout Properties
- Frozen Column
- Sequence Column
- Alternate Row Colors
- Show Border
- Border Color
- Grid Line Color
- Object Positions
- Object Dimensions
Object Columns Properties
Data Properties
- Selected column
- Column name
- Data Type
- Column Label
- Function
- Column filters
- Conditional Formatting
- Remove Column
- Decimal Places
- Thousand Sep.
- Mask
Styles