Table wizard—appearance

The Appearance dialog box allows to customize the appearance of the report table.

The fields and controls available in this dialog box are described in the following table.

Section Field Description

Table Appearance Settings

Theme

Select a table theme for the report.

 

For missing columns

Select either of the following options:

  • Hide column: Hide the column that is empty from the generated table report.
  • Show error: Show error if a column is missing from the generated table report.

 

Transpose Data

Switch the data to turn the columns in to rows.

 

Replace nulls

Select to replace null value (DBNull.Value) with the string value 'N/A'.

 

Display title

Display the title of the report table.

 

Return count

This option takes effect only when there is a single column in the table and returns a count of its elements. For example, consider a table with a single column of 200 Timestamp values, if the Return Option is selected, it will return a table with a single row with a value, and the value would be 200.

 

Display column header

Display the column header in the report table.

 

Repeat column header on every page

Repeat the column header on every page of the report table.

 

Header Text Alignment

Select the text alignment of the table header row from the list of options.

 

Adjust column widths to fit in a page

Adjust the column width to fit within a single page.

 

Columns per table

Use this option to view a specific number of columns per row.

Preview

 

View a preview of the table configuration.