| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
This is a Key Topic, with high value for all users.
...
In the Columns section of the Report Editor, you can 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.
To add a custom expression column, click
.
...
Enter a Column Name and select a Column Type, the data type of the column to be added. To enter a Column Expression, click
.
In the Custom Expression Editor, for each column:
Select a Column from the list and click
to insert it into the expression.Add any functions and values: You can make calculations, concatenate columns, or use an IIF statement.
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.
Click
. The Column Expression appears in the Column Expression field.
After creating the Column Expression,
...
to add it to the list of Available Columns, click
.To add the Column Expression to the list of Report Columns, select it in the list of Available Columns and click
.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.