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 .
   
   

   Open

   

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.
   
   

   Open

   

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.