8.1.1  Configuring an Embedded Table

To pass inputs from a Viewsheet to the underlying Worksheet, the Worksheet must contain an Embedded Table. Follow the steps below to add and configure the Embedded Table in the Worksheet.

1. In the Worksheet, click the 'New Object' button in the toolbar, and select the 'Embedded Table' option. The pointer changes to a crosshair.

Any cell in the Embedded Table can receive its value from a Viewsheet control.

2. Drag the mouse across the Worksheet grid to create the new Embedded Table. Create as many rows and columns as needed for the application.

3. Right-click the Embedded Table, and select 'Properties' from the context menu. This opens the 'Properties' dialog box.

4. In the 'Name' field, enter a name for the Embedded Table. This is the name by which you will identify the table in the Viewsheet.

5. Click 'OK' to close the 'Properties' dialog box.

6. Edit the column names, if desired. (Meaningful column names make it easier to bind the Viewsheet input control.)

7. Enter default values into the cells of the Embedded Table.

A cell that is linked to a Viewsheet control will be dynamically updated to the value set in the control. A cell that is not linked to a Viewsheet control will retain the fixed value you enter.

The Embedded Table is usually connected to other Data Blocks by one or more joins.

8. Connect the Embedded Table to other Data Blocks in the Worksheet, as desired.

See Also

Linking a Viewsheet to a Data Source, for an application example.

Creating an Embedded Table, in Data Mashup, for basic concepts.

Joining Tables, in Data Mashup, for information on creating joins.

Renaming a Column, in Data Mashup, to set column names.

<< 8.1 Using Input Components © 1996-2013 InetSoft Technology Corporation (v11.4) 8.1.2 Passing Inputs to an Embedded Table or Variable >>