Adding a Grid Expression

Apply conditions that dynamically alter the appearance of your data grid.

Implementation:

  1. Switch to the Definition tab.
  2. Double-click the grid you want to modify.
  3. Click Configure.
  4. Switch to the Expressions panel.
  5. Click Add in the Data Source Grid Definition window.
  6. Use the drop-down menu in the window to select an Expression Type. The remaining fields in this window will depend on the expression types you select. The compatibility table below shows the fields available for each expression type:
Row Expression Type Row Expression Selected Column Format String
Highlight Expression ✓    
Highlight Cell Expression ✓ ✓  
Is Selected Expression ✓ ✓  
Is Column Visible Expression ✓ ✓  
Derived Column Format String   ✓ ✓
Is Action Link Enabled Expression ✓ ✓  
Cell Style Expression/Header Style Expression ✓ ✓  
Row Style Expression ✓    
Is Action Link Visible Expression ✓ ✓  

These expressions are evaluated once for each row in your grid, and work best when used in conjunction with Column Keywords. When each row is evaluated, the column keyword takes the value of whatever is in the cell, where that column and the row being evaluated meet.

  1. Type the expression you want to evaluate in the Row Expression field, or use the button to the right-hand side of the field to open the Expression Editor.
  2. (Expression Type specific) Use the Selected Column drop-down menu to choose one of the fields in your selected data source you want the expression to affect.
  3. Click Save to close the window and return to the grid definition.

Repeat these steps if you want to add another expression to your grid. You can add and configure as many expressions as you want.