Table Elements

General

Table report element can be used to export data in tabular form into the Template.

General Properties

This type of report element has the following general properties:

Insertion Modes

This chapter describes the various insertion modes that may be used to insert a table into the report document.

Create New Table

When setting the Insertion Mode property to Create New Table the exported table will be written to the report document as a new table. When dragging and dropping the report element from the content explorer of the Report Designer into the Template, a placeholder referencing the table element with the following syntax will be inserted:

In the template, the placeholder looks like this:

Table Element PlaceHolder

When the report document is created, the placeholder will replaced with a newly created table.

Write into Existing Table

This insertion mode can be used to write the exported table into an existing table within the Template. When dragging and dropping the report element from the content explorer of the Report Designer into the Template, a placeholder referencing the table element with the following syntax will be inserted:

A new property Existing Table Insertion Mode will be available. If set to Overwrite, the placeholder referencing the table element may be placed in any row of the existing table. The cell that contains the placeholder will be the starting cell (the top left cell of the exported table); when creating the report document, the exported table will be written into the cells of the existing table. An error will occur if the existing table does not have enough rows to hold the exported table. When setting the Existing Table Insertion Mode property to* Insert Rows*, the placeholder referencing the table element may be placed in any row and there must be at least one row below the row that contains the placeholder. Mail & Deploy will automatically insert the required amount of rows and use the row that contains the placeholder as a template for all header rows of the table and the row directly below the row that contains the placeholder as the template row for all data rows of the table. An error will occur if the existing table does not have at least one row below the row that contains the placeholder.

Fill MSO Chart

When setting the Insertion Mode property to Fill MSO Chart the exported table will not be directly written to the report document. Instead, you can add an MSO chart (a Microsoft Office Chart) in the Template and use the table element to feed data to it when creating the report document. To create a link between the MSO chart and the table element, you have to right-click the MSO chart and select Edit Alt Text. As alternative text, enter a placeholder for the table element in the following syntax:

In a template edited with Microsoft Word 2019, a table report element named MyTableElement would be referenced like this:

Referencing a Table Element from MSO Chart Alternative Text

When selecting an Insertion Mode of Fill MSO Chart new properties will become available to specify MSO Chart Settings by which you can dynamically set properties of the MSO chart that the table element feeds with data.

Cell Settings

These settings can be used to manipulate properties of cells of the exported table. Every table report element has Default settings and (optionally) a number of custom cell settings. For every cell of the exported table, the applicable cell settings are evaluated; if custom cell settings are found, they are applied, otherwise the default settings are used.

Default Settings

The default cell settings are applied to all cells for which no custom cell settings have been found. They have the following properties:

Custom Settings

You can specify zero or more custom cell settings which will be used with a higher priority than the default cell settings. Custom cell settings have the following additional properties:

Expression Parameters

These are the available expression parameters for custom cell value and condition Expressions of cell settings:

Example 1

Let's suppose you only have default cell settings (i.e. no custom cell settings) and you have the following custom value expression set up:

Since there are no custom cell settings, the default settings are applied to all cells of the table. The custom value expression leads to the cell in the first column and second row to have the text Hello World; all other cells with keep their original value (defined by the [CellValue] expression parameter).

Example 2

Let's suppose you have custom cell settings with a selector Depending on Column Number and a column number range of 1 to 3 where the style application mode is set to Custom and the Bold style property of the custom style is set to Yes. The default settings have a style application mode of Keep Original. In that case, all cells to which the custom cell settings apply (all settings in the 1st to 3rd column) will have a bold text. All other cells will keep their original style, because the default cell settings are applied.