Lesson 7: Working with graphs and Indicator in SSRS (Tutorial)

Adding a bar graph to report

Add a duplicate copy of column “Price”. Rename the header as “Price Analysis”

Right click on the new row “Price”. Select Insert and the select the option “Data Bar”.

In the “Select Data Bar Type” window, select the “Stacked Bar”. Click Ok.

Right click on the Data Bar and from the context menu, choose Chart Properties.

In the General section of the Chart Properties window, choose Gray Scale from the Color Pallet drop down.

And in the Fill section, choose Gradient in the Fill Style and provide some suitable gradients. Click Ok

Preview the report.

Right click on the Data Bar and from the context menu,choose Horizontal Axis Properties.

From the properties dialog check the Reverse Direction checkbox of the Scale options. Click OK.

Preview the Report.

Adding an indicator to report

Right click on the new row “Price”. Select Insert and the select the option “Indicator”.

The Indicator Type properties window appears. From there let us choose the "3 Arrows (colored)" Directional Indicator type. Click Ok.

Right click on Indicator, select Indicator Properties.

We can change the value and states of the Indicator from the Values and States option available in the Indicator Properties. We can even add more indicator states. The default is shown below. Click Ok.

Preview the report.

Related topics:

Lesson 1: CREATE A SIMPLE SSRS REPORT (TUTORIAL)
Lesson 2: CREATE A SSRS REPORT WHICH EXCEPTS INPUT PARAMETER (TUTORIAL)
Lesson 3: CREATE DRILL DOWN VIEW IN SSRS (TUTORIAL)
Lesson 4: NAVIGATING BETWEEN SSRS REPORTS (TUTORIAL)
Lesson 5: WORKING WITH SUB REPORT IN SSRS (TUTORIAL)
Lesson 6: WORKING WITH EXPRESSIONS IN SSRS (TUTORIAL)
Lesson 8: MISCELLANEOUS OPTIONS IN SSRS (TUTORIAL)