Add KPI to report by Reporting Service

Source: Internet
Author: User

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 ".

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.