Add KPI to report by Reporting Service

1. Use the background color to display the current KPI status
In the table, right-click the cell that contains the [linetotal] field and select "text box attribute ". In "fill", type the following expression:

= IIF (sum (Fields! Linetotal. Value)> = 30, "Transparent", IIF (sum (Fields! Linetotal. Value) <20, "Red", "yellow "))

For each cell whose line total value is less than 20, the background color is red. All values between 20 and 30 are displayed in yellow. values greater than 30 are not highlighted.

2. Use a gauge to display the current KPI status
In the table, right-click the cell that contains the [linetotal] field, point to "insert column", and select "Next" to insert a new column to the right of [linetotal. Click the design tab. In the toolbox, click meter, and then click the design surface outside the table. The Select Instrument Type dialog box is displayed.

Click linear ". The first linear meter is selected.
Click OK ". Drag the linetotal field from the report data pane to the gauge.
When you drag this field to the meter, the built-in sum function is used to aggregate this field.
Drag the instrument in the table to the column inserted in step 1

Click Preview ".