TechNet
Export (0) Print
Expand All

Set and Configure Measurement Units (Report Builder and SSRS)

 

Applies To: SQL Server 2016

In a Reporting Services paginated report, indicators use one of two measurement units: percentage or numeric.

By default, indicators are configured to use percentages as the measurement unit. This means that the indicator values assigned to each icon in the indicator set are determined by a percentage range. The percentage ranges are evenly divided across the icons in the indicator set. Each icon represents an indicator state. You can change the percentages for each icon in the indicator set by specifying different start and end percentages. Indicators also automatically detect the minimum and maximum values in the data.

You can change the measurement unit to be a numeric value. In this case, you do not specify minimum or maximum for the data; instead, you provide only the start and end values for each icon that the indicator uses.

Options such as measurement units can be set by using expressions. For more information, see Expressions (Report Builder and SSRS).

  1. Right-click the indicator you want to change and click Indicator Properties.

  2. Click Values and States in the left pane.

  3. In the States Measurement Unit list, click Numeric.

    Optionally, click the Expression (fx) button to edit an expression that sets the value of the option.

  4. For each icon in the indicator set, update the values in the Start and End text boxes.

    Optionally, click the Expression (fx) button to edit an expression that sets the values of the Start and End options.

    System_CAPS_ICON_note.jpg Note


    The values in the Start and End text boxes must be numeric.

  5. Click OK.

  1. Right-click the indicator you want to change and click Indicator Properties.

  2. Click Values and States in the left pane.

  3. In the States Measurement Unit list, click Percentage.

    Optionally, click the Expression (fx) button to edit an expression that sets the value of the option.

  4. Optionally, change the Minimum and Maximum options to use specific values instead of automatically detecting the minimum and maximum values of the data that the indicator uses. The value of Minimum must be smaller than the value of Maximum.

    System_CAPS_ICON_note.jpg Note


    If you explicitly set minimum and maximum values, that value range is used by the indicator regardless of the actual the minimum and maximum values in the data. This means that values lower than the minimum and higher than the maximum are excluded from the evaluation that determine what indictor icon to show in the report.

    Optionally, click the Expression (fx) button to edit an expression that sets the values of the option.

  5. For each icon in the indicator set, update the values in the Start and End text boxes.

    Optionally, click the Expression (fx) button to edit an expression that sets the values of the Start and End options.

    System_CAPS_ICON_note.jpg Note


    The values in the Start and End text boxes must be numeric.

  6. Click OK.

Indicators (Report Builder and SSRS)

Community Additions

ADD
Show:
© 2016 Microsoft