Adding a Column to an Existing Table

There are two parts to adding a column to an existing table: Update the SQL Query and Edt the Data Binding Properties.

To Update the SQL Query

1.

Click New Data Source link at the bottom of the Dashboards Objects panel.

2.

On the Data Source Manager, select the data source on the list to modify.

3.

Click Edit to open the Edit Data Source dialog box.

4.

Click the Select tab.

5.

Click Add to add a field.

6.

Click OK to save your changes.

NOTE: If you have a Manually Typed data source, you might need to manually edit the SQL Query. However, if you have a state that contains code such as “Select*”, then it will already query for all the columns in the table.

Edit the Data Binding Properties

1.

Select the Table on the Dashboard.

2.

In the Properties area, locate the Data > Data Binding field.

3.

Click the ellipses button (...) to open the Table View Data Binding dialog box.

4.

There are two list boxes:

○ Unbound fields (columns) contains columns that are not available for display in the table.

○ Bound fields contains columns that can be displayed in the table.

5.

Select an item from the Unbound fields list and then use the Right Arrow button (or double-click the field name) to move it to the Bound Fields.

6.

Click OK to save your changes.