Walkthrough: Selecting and Creating Columns in Data Binding Wizard
Walkthrough
This example is continued from the previous section, Walkthrough: Choosing the Binding Data Source.
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 following columns from the tree on the left by selecting the column and clicking on the right-arrow button:
You can remove any selected fields by using the left-arrow button.
'Customer.Company'
'Product.Quantity Purchased'
'Order.Discount'
'Product.Name'
'Product.Price'

For data models only, if you want the generated query to use full-outer joins rather than the model's predefined joins, select 'Include all rows', beneath the right panel. (Note: This may return a very large amount of data.)

3. Select 'Price' and click the 'Hide/show column' button to hide the column.


4. Select the 'Create formula' button.
5. Enter the name “TotalDiscount” and select 'Float' for the return data type.


6. Make sure 'Script' is selected and click on the 'Edit' icon.
7. Enter the following formula either by typing directly or by selecting the appropriate fields from the GUI:
field['Order.Discount'] * field['Product.Total'];

8. Click the 'Save and Close' button, and click 'OK' in the 'Formula' dialog box to add the formula column to the columns list.

This example is continued in the following section, Walkthrough: Adding Conditions in Data Binding Wizard.
| << Creating a Formula Column in Data Binding Wizard | © 1996-2013 InetSoft Technology Corporation (v11.5) | 6.2.4 Filtering Data in Data Binding Wizard >> |