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:
|
|
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. |