Dragging and Dropping data in Run-time

You can add data to an existing chart or grid by dragging and dropping the data source onto the object in a display. For example, if you select a source data item and drag the item onto a Pie chart, the item is added to the Pie chart as a new category. For a detailed procedure, see To add data to an object in run-time.

Data can also be transferred from one object to another with drag-and-drop. For example, you can drag data from a list box onto a grid, and the data from the list box will appear as a new column on the grid. Real time data, SQL data, and historical data can be used with these drag and drop methods. The objects that support transfer of data to a grid are List Boxes, Combo Boxes, and Trees. For a detailed procedure, see To transfer data from a List/Combo Box or Tree to a Grid.

NOTE: Only SQL SELECT statements are supported for drag-and-drop. You cannot drag and drop an INSERT, UPDATE, or DELETE statement.

To add data to a chart or grid in run-time

  1. Select the Data Sources tab

  2. Navigate to the data source item you want to add to the object.

  3. Drag the item from the Data Sources tab and drop it onto the object you want to modify. The Edit Source dialog box appears.

  4. In the Edit source dialog box, change any options as required. See Data Sources if you require more information.

  5. Click OK

To transfer data from a List/Combo Box or Tree to a Grid

NOTE: Data can be transferred from a List/Combo Box or Tree object only if configured with the Manual Entry option (for data source selection). This option is set in the object's configuration panel.

  1. In run-time, select the item in the List Box, Combo Box, or Tree that you want to add to the grid.

  2. Drag the item with your mouse and place it over the grid. You will see an outline around the grid.

  3. Drop the item. The Edit Source dialog box appears.

  4. In the Edit source dialog box, change any options as required. See Data Sources if you require more information.

  5. Click OK.

The data item appears as a new column in the grid.

See Also

Combo Box and List Box

The Tree Object

Grids

Grids at Run Time