Merge Report Properties

Merge report properties are defined on the Properties tab of the Merge Report window when merging a report into HTML content. In addition to merge report properties, other properties are available when merging into text content. The available properties depend on the option you select in the Output Type field.

Merge Report Properties

Field Description

Output Type

Click this drop-down list to select the output type option. Output types define how your report data displays when it is merged into your HTML content. Options include the following:

Table—Displays report data as a table.

Record—Displays report data as a record, without table rows.

List—Displays report data as a list.

Single Value—Displays only the value of the field in the first row and first column of your report content.

Max Rows

Enter the maximum number of rows for the report data. Click the up or down arrow to increase or decrease the value.

This field is available only for Table, Record, and List output types.

Table Properties

The settings in this section define the appearance of the table when it is merged into your HTML content.

Table properties are available only when the Output Type field is set to Table.

Caption

Enter the caption you want to appear at the top of the table.

This setting is also available when merging a report into text content.

Table Style

Enter any style attributes you want to apply to the table.

Table Class

Enter any class attributes you want to apply to the table.

Caption Style

Enter any style attributes you want to apply to the table caption. Style attributes define how the text appears. For example, color: red; font-weight: bold; font-style: italic.

Column Headers

Select this check box to display column headers for the table.

This setting is also available when merging a report into text content.

Column Header Style

Enter any style attributes you want to apply to the column headers of the table. Style attributes define how the text appears. For example, color: red; font-weight: bold; font-style: italic.

Column Header Class

Enter the class name you want to apply to the column headers of the table. You must define the class in your HTML content by either using the <style> tag to define the class inline, or posting the class in a CSS file on your web server and referencing it with the <link> tag.

Cell Style

Enter any style attributes you want to apply to the table cells. Style attributes define how the text appears. For example, color: red; font-weight: bold; font-style: italic.

Cell Class

Enter the class name you want to apply to the table cells. You must define the class in your HTML content by either using the <style> tag to define the class inline, or posting the class in a CSS file on your web server and referencing it with the <link> tag.

Cell Format

Click this drop-down list to select a case format for the table cells. Options include Lowercase, Uppercase, and Proper Case (which capitalizes the first letters of every word).

This setting is also available when merging a report into text content.

Width

Enter the width of the table and select pixels or percent from the drop-down list.

Border

Enter the width, in pixels, of the table border.

Frame

Click this drop-down list to apply an HTML style to your frame. Options include the following:

Void—Outside borders are not shown.

Above—Top outside border is shown.

Below—Bottom outside border is shown.

Hsides—Top and bottom outside borders are shown.

Vsides—Left and right outside borders are shown.

Lhs—Left outside border is shown.

Rhs—Right outside border is shown.

Box—Outside borders are shown on all four sides.

Border—Outside borders are shown on all four sides.

Rules

Click this drop-down list to apply an HTML style to the lines in your table. Options include the following:

None—No lines are shown.

Groups—Lines are shown between row groups and column groups.

Rows—Lines are shown between rows.

Cols—Lines are shown between columns.

All—Lines are shown between rows and columns.

Cell Padding

Enter the padding, in pixels, of the table cells.

Cell Spacing

Enter the spacing, in pixels, of the table cells.

Primary Background Color

Click this color box to select a primary color for the table cell background or enter the HTML hexadecimal value of the color in the field to the right of the color box.

Alternating Background Color

Click this color box to select a color for the alternating table cell background or enter the HTML hexadecimal value of the color in the field to the right of the color box.

The alternating backgound color helps with readability by adding color variation from one table row to the next.

Border Color

Click this color box to select a primary color for the table border or enter the HTML hexadecimal value of the color in the field to the right of the color box.

Record Properties

The settings in this section define the appearance of the record when it is merged into your HTML content.

Record properties are available only when the Output Type field is set to Record.

Record Style

Enter any style attributes you want to apply to the entire record.

Record Class

Enter any class attributes you want to apply to the entire record.

Row Style

Enter any style attributes you want to apply to the record rows.

Row Class

Enter any class attributes you want to apply to the record rows.

Header Style

Enter any style attributes you want to apply to the row headers of the record. Style attributes define how the text appears. For example, color: red; font-weight: bold; font-style: italic.

Header Class

Enter the class name you want to apply to the row headers of the record. You must define the class in your HTML content by either using the <style> tag to define the class inline, or posting the class in a CSS file on your web server and referencing it with the <link> tag.

Value Style

Enter any style attributes you want to apply to the entered values of the record. Style attributes define how the text appears. For example, color: red; font-weight: bold; font-style: italic.

Value Class

Enter the class name you want to apply to the entered values of the record. You must define the class in your HTML content by either using the <style> tag to define the class inline, or posting the class in a CSS file on your web server and referencing it with the <link> tag.

Format

Click this drop-down list to select a case format for the record values. Options include Lowercase, Uppercase, and Proper Case (which capitalizes the first letters of every word).

This setting is also available when merging a report into text content.

Horizontal Rule

Clear this check box to remove the horizontal lines that display between your record rows. This check box is selected by default.

Primary Background Color

Click this color box to select a primary color for the background of the record or enter the HTML hexadecimal value of the color in the field to the right of the color box.

Alternating Background Color

Click this color box to select a primary color for the alternating background of the record or enter the HTML hexadecimal value of the color in the field to the right of the color box.

The alternating background color helps with readability by adding color variation from one record to the next.

List Properties

The settings in this section define the appearance of the list when it is merged into your HTML content.

List properties are available only when the Output Type field is set to List.

Ordered List

Select this option to display a numbered list.

Unordered List

Select this option to display a bulleted list.

List Style

Enter any style attributes you want to apply to the list text. Style attributes define how the text appears. For example, color: red; font-weight: bold; font-style: italic.

List Class

Enter the class name you want to apply to the list text. You must define the class in your HTML content by either using the <style> tag to define the class inline, or posting the class in a CSS file on your web server and referencing it with the <link> tag.

Format

Click this drop-down list to select a case format for the list text. Options include Lowercase, Uppercase, and Proper Case (which capitalizes the first letters of every word).

This setting is also available when merging a report into text content.

Single Value Properties

The settings in this section define the appearance of the values of the field in the first row and first column of your report content.

Single value properties are available only when the Output Type field is set to Single Value.

Format

Click this drop-down list to select a case format for the single value text. Options include Lowercase, Uppercase, and Proper Case (which capitalizes the first letters of every word).

This setting is also available when merging a report into text content.

Style

Enter any style attributes you want to apply to the single value output. Style attributes define how the text appears. For example, color: red; font-weight: bold; font-style: italic.

Class

Enter the class name you want to apply to the single value output. You must define the class in your HTML content by either using the <style> tag to define the class inline, or posting the class in a CSS file on your web server and referencing it with the <link> tag.

Note: Regarding class attributes, because few third-party mail clients consistently support CSS, you should use style attributes instead of CSS.