Indicators are small graphical iconic tools that visually shows the state of a single data value at a glance. The indicators are visually effective to show the trends, state, conditions and ratings in quick way.
The indicators can be used to show the following situation in reporting:
- Trends by using increasing up arrow icon, Horizontal or flat for no change in trend, or decreasing arrow icon.
- State by using commonly used symbols to indicate the context.
- Conditions by using commonly symbols and shapes that convey conditional action. Eg. traffic lights and signs.
- Ratings by using commonly used shapes and symbols that show progress. The progress can be indicated by number of quadrants in a square and stars.
Indicators can be used in dashboards or normal reports. The use of indicators are mostly observed in tabular and matrix forms of reports. The following tutorial teaches how to use indicators in reports which we have already made in chapter-14.
Open SSRS report in design view which we have made in chapter-14. Delete the fifth column that represent Data Bar i.e., Stock Position by right click on column and press delete from drop down as shown.
Insert a column right to the “Units in Stock” and choose again the same column value “Units in Stock” as shown.
Rename the Header label of the last column to Indicator. From the Report Toolbar Drag and Drop the Indicator tool to the 5th Column with header Indicator “Select Indicator Type” window will appear let us choose “4 Arrows(colored)” and click ok as shown.
We can change the value and states of the Indicator from the Values and States option available in the Indicator Properties. For doing this right click on column Header with name “Indicator” and choose indicator properties as shown.
An Indicator Property windows will appear go to Value and State option as shown and change the start and end value as desired.
Click on ok button and Preview the Report, the following screen will appear.
This completes “Chapter-15-Displaying Indicators”.
Chapter-1: Creating a basic Tabular SSRS Report using Report Wizard
Chapter-2 : Report Deployment on SQL Server 2012 Reporting Server
Chapter-3:Opening/Calling the deployed SQL Server Reporting Server report from Asp.net
Chapter-4 Creating SSRS Matrix Report / Cross Tab Report
Chapter-5 Creating a Sub Report in SSRS
Chapter-6: Creating a Drill Down Report in SSRS
Chapter-7: Working with expressions and custom code in SSRS
Chapter-8-SSRS (Reporting Services) Working with Calculated fields
Chapter-9-Sorting of Column and Custom Paging in SSRS
Chapter-10 : Creating and Deploying Web Services for SSRS
Chapter-11 : Creating SSRS Report by consuming Web Service Data Source
Chapter-12 : Working with Data Bars in SSRS
Chapter-13-Displaying Color in Data Bar Based on Condition
Chapter-14- Displaying Data Labels along with Data Bars in SSRS