A table element can be used to insert a tabular representation of data into the report template during the creation of the report document.
Table elements have in addition to the general attributes (see General Attributes) which all report elements have - the following attributes:
|Datasource Object||The datasource object (see Objects) from which you want to get the tabular data.|
|Included Cell Types||Determines which cell types (see Table Cell Styles) of the source table shall be included in the table that is written to the report document.|
|Direction ||The direction in which the output table shall be written to the report document.|
Please note, that this option is not available for pivot tables.
By specifying column specifications, you can control which columns of the source table (e.g. the table in the datasource) will be included in the report an in which order. The order of the column specifications controls the order of the columns in the table that will be written to the report document.
Column Specifications have the following attributes.
|Type||The type of column specifications, which can be one of the following values:|
All Source Columns.
When you use this type, the column specification will include all columns of the source table and apply its settings to them.
Named Source Columns.
When you use this type, you can select a column of the source table by its name, if the datasource object (see Objects) of the table report element supports named columns.
Source Column by Number.
When you use this type, you can specify a column number which addresses the column at that position in the source table.
Source Column Range.
When you use this type, you can specify a start and end column number which addresses the range from the start column number to the end column number in the source table.
|Width||Specifies the method by which the width of all columns addressed by the column specification shall be determined when writing the table to the report document.|
Do Not Set.
The width of the columns is not set by Mail & Deploy at all.
The width of the columns shall be automatically determined by the size of the content of all cells belonging to each column.
If you select this option, you can specify an expression (see Expressions) that evaluates to the custom column width in pixels.
|Cell Type Settings||These settings allow you to control whether each cell of a given cell type (see Table Cell Types) has a custom content; if activated, you can specify an expression (see Expressions) that evaluates to the value of each cell of that cell type. You can also set how each cell type of each column of the column specification shall be styled (see Table Cell Styles) when writing the table to the report document. For each cell type you have the following options:|
If you choose this option, Mail & Deploy will not set any style for the given cell type; thus, whatever style is set in the report template will be kept.
If you choose this option, Mail & Deploy will keep the style of the original table in the datasource (see Datasources). Please note, that not all style elements may be kept, because this also depends on the type of datasource.
If you choose this option, you can select a specific datatable cell style (see Table Cell Styles) to apply to the cell type.
If the datasource object (see Objects) that is the source of the table report element is a pivot table, the following additional attributes can be set:
|Indent Rows||If this attribute is enabled, all columns with left header cells (see Table Cell Types) will be combined to one single column and all left header cells will receive an indent depending on the level they belong to.|
|Merge Vertically||If this attribute is enabled, consecutive dimension header cells in the vertical direction of the pivot table that contain the same value will be merged. Also, you can define which vertical alignment the content of the merged cells shall have.|
|Merge Horizontally||If this is attribute is enabled, consecutive dimension header cells in the horizontal direction of the pivot table that contain the same value will be merged. Also, you can define which horizontal alignment the content of the merged cells shall have.|