Selecting Columns in Data Binding Wizard

The fields that you select from the Columns tab will be returned by the data source and displayed by the report element. To select columns from the data source, follow the steps below:

1. In the 'Data Binding' dialog box, select the Columns tab. (See Creating a New Table, Crosstab, or Section using a Wizard for information on how to access the 'Data Binding' dialog box.)

2. Add the desired columns from the 'Available Columns' panel to the right panel. You can do this by any of the following methods:

a. Double-click a column in the 'Available Columns' panel to add it to the right-side panel.

b. Click to select a column (or Shift/Ctrl-click to select multiple columns) in the 'Available Columns' panel. Drag the selected column(s) to the right-side panel.

The left arrow removes a selected field.

c. Click to select a column (or Shift/Ctrl-click to select multiple columns) in the 'Available Columns' panel. Click the right-arrow button to add the selected column(s) to the right-side panel.

 

The left “multi-arrow” removes all of the selected fields.

d. Click the right “multi-arrow” to select all of the fields in the 'Available Columns' panel.

 

e. For a data model, click to select an entity (or Shift/Ctrl-click to select multiple entities) in the 'Available Columns' panel. Click the right-arrow button to add all of the selected attributes from the selected entity to the right-side panel.

6. To change the ordering of a selected column, click to highlight the column, and then press the 'Move up' and 'Move down' buttons.

 

7. Click 'Finish' to close the 'Data Binding' dialog box, or continue with other desired modifications.

To remove a field from the right-side panel, select the field and click the left-arrow button. In general, fields that are not among the selected fields (in the right-side panel) are removed from the query that is sent to the database. However, in cases where the data binding specifications cannot be merged into the original query, the full query is executed and all query fields are returned. Nevertheless, only the selected fields are displayed in the report element.

<< 6.2.3 Specifying Columns in Data Binding Wizard © 1996-2013 InetSoft Technology Corporation (v11.4) Sorting Columns in Data Binding Wizard >>