4.8.1 Setting Table Query and Display Properties
You can change various properties of a Data Table, such the table description, maximum number of rows retrieved and displayed, and the handling of duplicate rows.
To change table properties, follow these steps:
1. Right-click the title row, and select 'Properties' from the context menu. This opens the 'Table Properties' dialog box.
2. Change the desired properties, and click 'OK' to exit the dialog box.

The table properties are described below.
Property |
Description |
Description |
The description text is displayed as a tooltip when the mouse hovers over the Table icon in the table's title row, and when the table is selected in Style Studio. (See Using a Data Table for information about binding tables.) |
Max Rows |
The maximum number of rows to retrieve from the database at runtime and to display in table preview. This is also the maximum number shown in Live Preview mode when 'Max Rows' is less than 'Max Display Rows'. (See Previewing a Table and Showing Live Data in a Table.) |
Return Distinct Values |
Display only distinct rows in the table. (Remove duplicate rows.) |
Merge SQL |
When selected, the Worksheet attempts to generate the table by forming a single SQL query, thus delegating all of the data manipulations to the database. If this option is not selected, or if the unified SQL statement cannot be formed, the table is generated in post-processing. (See Viewing the SQL Query Plan of a Table for information on viewing a table's query.) In certain cases, you can improve Viewsheet performance by disabling the 'Merge SQL' option. |
Live Preview |
Display live data in the table, rather than meta-data. When displaying live data, it is recommended that you set the 'Max Rows' property to prevent the query from returning a very large number of records. Live Preview can also be enabled from the 'Change View' button on the table title bar. See Showing Live Data in a Table. |
Max Display Rows |
Maximum number of table rows to retrieve and display in Live Preview mode. (See Showing Live Data in a Table.) This property does not affect the number of records retrieved from the database at runtime or during preview. If 'Max Rows' specifies a smaller value, the 'Max Rows' value is used as the Live Preview maximum. |
| << 4.8 Table Operations | © 1996-2013 InetSoft Technology Corporation (v11.5) | 4.8.2 Viewing the SQL Query Plan of a Table >> |