SQL Server Reporting Services SSRS Indicators

  • (4.0)

SSRS Indicators

Indicators are a visual way of assigning categories to values. In the same way that conditional formatting in Excel might be used to highlight any negative values in red, low numbers in orange and high numbers in green, in reports, you can add an indicator to show a number of conditions.

A common indicator is the ‘traffic light’, which can be used to show whether certain targets have been met or not. Green for yes, amber for almost, and red for no, etc.

Learn how to use SSRS, from beginner basics to advanced techniques. Enroll for Free SSRS Training Demo!

A number of indicators are supplied that can be used with minimal configuration.All you need to do is decide what value from the report’s data will set the condition of the indicator, and then set the boundary ranges e.g. 0-100 = Green, 101-200 = Amber, 201-1000 = Red.


Try it

1. Open the Employee Contribution report and add a column to the right of the existing data.(right click on TotalDue and Insert Column > Right)

2. From the Toolbox, drag an indicator into the new, empty data cell in the column that was just inserted.

3. From the Select Indicator Type window, choose the ‘3 stars’ indicator from the Ratings section and click OK.

4. Click once on the indicator to open the Gauge Data panel, then open the Indicator Properties window by clicking on the small arrow next to ‘Indicator 1’ in the Values section.

5. In Indicator Properties, open the Values and States page and set the value to [Sum(TotalDue)], the measurement unit to Numeric and the indicator states as shown below.

Related Page: Working With SSRS Reporting Services Configuration Manager

6. Click OK

7. Preview the Summary Sales report, select a year, and then select a month to open the Employee Contribution report.

Frequently Asked SSRS Interview Questions & Answers

List of Related Microsoft Certification Courses:

 SSIS  Power BI
 SSAS  SQL Server
 SharePoint  BizTalk Server
 Team Foundation Server  BizTalk Server Administrator


Popular Courses in 2018

Get Updates on Tech posts, Interview & Certification questions and training schedules