IMOS - Custom Expressions

 This is a Key Topic, with high value for all users.

In the Columns section of the Report Editor, you can add a custom column to the report that will display calculated values based on a formula and/or an expression you specify for it. You might use this to combine two columns into one, as in the example below.

Note: For additional information, see the Microsoft expression editor documentation at http://msdn.microsoft.com/en-us/library/system.data.datacolumn.expression.aspx.

1. To add a custom expression column, click  .
   
2. Enter a Column Name and select a Column Type, the data type of the column to be added. To enter a Column Expression, click .
   
3. In the Custom Expression Editor, for each column:
   1. Select a Column from the list and click to insert it into the expression.
   2. Add any functions and values: You can make calculations, concatenate columns, or use an IIF statement.
   3. Use any of the following macros:
      • _NOW_: Gives the current date and time of issuing the report.
      • _NOW_UTC: Gives the UTC current date and time of issuing the report.
      • TODAY: Gives the current date, with time set to 00:00:00.
   4. Click . The Column Expression appears in the Column Expression field.
4. After creating the Column Expression, to add it to the list of Available Columns, click .
5. To add the Column Expression to the list of Report Columns, select it in the list of Available Columns and click .
6. To change the Text Color, Background Color, or Font Weight for a column to highlight particular data, click .  You can even set conditional color or font weight that changes based on the value of the data. In the editor, insert a column and then insert its color or font weight.