Table Properties: Advanced Tab

The Advanced tab in the 'Table Properties' dialog box provides the following Table-specific properties:

Note: Editable tables cannot be filtered by Selection Components.

Shrink to Fit

When enabled, this reduces the height of the table to match the number of records displayed. For example, if the original table height (as designed) was 10 rows, and the user then makes selections which restrict the result set to five rows, the table's bottom border will retract or “shrink” to eliminate any empty rows at the bottom of the table.

Embedded Table

When enabled, specifies that the table is an Embedded Table. This makes the table cells editable by the user and removes any hyperlinks. (This option is only available if the table was originally created as an Embedded Table. See Creating an Embedded Table for more information.)

Enable Table Editing

This option allows users to modify various aspects of a table by inserting, removing, or changing data records. To perform validation checks on data entered by users, see Setting Column Editing Options. Modified table data can be written back to the database by an appropriate Viewsheet script. See Accessing User-Modified Data in a Table in Dashboard Scripting for information. The 'Add Rows', 'Delete Rows', and 'Edit Rows' settings are discussed below. Note: Editable tables cannot be filtered by Selection Components.

Add Rows

Allows a user to add new rows to the table. To add a new row, the user should right-click a row in the table and select 'Insert Row' or 'Append Row' from the context menu to respectively add a row before or after the clicked row. Added rows are not retained across sessions unless they are committed to the database by a Viewsheet script (see above). See Setting Column Editing Options for information about validation.

Delete Rows

Allows a user to delete rows from the table. To do this, the user should right-click a row in the table and select 'Delete Row' from the context menu. Deletions are not retained across sessions unless they are committed to the database by a Viewsheet script (see above).

Edit Rows

Allows a user to edit data in the table. Edited data is not retained across sessions unless committed to the database by a Viewsheet script (see above). See Setting Column Editing Options for information about validation.

Data Tip View

A Viewsheet component is displayed when mouse hovers over table area. The component is filtered based on the hover region. See Data Tip View for more details.

Flyover Views

Allows you to select a set of Viewsheet components which will be adaptively filtered as the user hovers the mouse or clicks on the table area. (Select 'On Click Only' if you want the filtered components to update when the user clicks.) If the table contains aggregated data, filtering is based on the grouping fields (dimensions) in the row on which the user hovers or clicks. If the table contains detail data, filtering is based on the non-numeric columns in the row on which the user hovers or clicks. See Flyover View for more details.

Note: End-user table editing options are available only if product is licensed for Viewsheet Forms.

 

See Also

Accessing User-Modified Data in a Table, in Dashboard Scripting, for information on reading and committing modified data.

<< Table Properties: General Tab © 1996-2013 InetSoft Technology Corporation (v11.5) 4.1.4 Setting Column Editing Options >>