Creating Ad Hoc Reporting Columns

To create an expression column, follow the steps below:

1. Launch any one of the Ad Hoc Wizards. In Step 1, select the desired data source.
2. Proceed to Step 2 of the Wizard. Note the �Create Expression Column� link at bottom.
3. Click the ‘Create Expression Column’ link. This opens the Formula Editor.
4. In the �Name� field, enter a name for the new column.
5. Select the �Return Data Type�, which is the type of data the new column contains.
6. In the Formula Editor, select the �sql� checkbox to enter the formula using SQL syntax. Leave the box unchecked to use JavaScript syntax.
7. Construct the desired formula using appropriate operators (SQL or JavaScript). To add a field name to the formula, click the desired name in the �Fields� list.
• For example, you can specify an SQL formula such as
  field ['Price'] * field['Discount'] with return data type �Double�.


• You can specify a JavaScript formula such as the following with return data type �String�:
  if (field['Discount'] > 0) { 'Yes'; // return Yes } else { 'No'; // return No }