Gauge Data Region in SSRS

Gauge Data Region in SSRS

In this article I will show you how to use Gauge Data Region in SSRS.

There are two types of gauges: radial and linear. The following illustration shows the basic elements of a single radial gauge in the gauge panel.

1-Gauge Data Region in SSRS

 

First of all create table named as TopFootballPlayers in Database and insert some data as in following script. You will find the script on below link :

http://bhushan.extreme-advice.com/indicators-in-ssrs-report/ (Step 1)

1. Now open Visual Studio 2010 and open your SSRS project. Then add report named as DemoGaugeReport in your project.

Now create a Dataset. In the dataset, we will use following query.

SELECT	*
FROM	TOPFOOTBALLPLAYERS
WHERE	NO = @RANK

2. Right click on report area and go to Insert–>Gauge.

2-Gauge Data Region in SSRS

3. A Select Gauge Type window opens. In that select Radial from left Pane & Select Radial from it. Then click on OK button.

3-Gauge Data Region in SSRS

4. Now your report design look like below screenshot.

4-Gauge Data Region in SSRS

5. Then click on Pointer & select InternationalGoals as shown in below screenshot.

5-Gauge Data Region in SSRS

6. Then right click on Scale & select Scale Properties as shown in below screenshot.

6-Gauge Data Region in SSRS

7. A Radial Scale Properties window opens. In that modify values of Minimum, Maximum & Interval as shown in below screenshot. Then click on OK button.

7-Gauge Data Region in SSRS

8. Then right click on Range & select Range Properties.

8-Gauge Data Region in SSRS

9. A Radial Scale Range Properties window opens. In that modify values of Start Range & End Range as shown in below screenshot. Then click on OK button.

9-Gauge Data Region in SSRS

10. Now drag & drop one text-box from toolbox and add it above gauge chart. In text-box add text Goals of and data field PlayerName as shown in below screen.

10-Gauge Data Region in SSRS

You can also modify appearance of scale, pointer, range, pointer cap etc.

11. So we have done with the Gauge Report. To see the results click on preview tab.

11-Gauge Data Region in SSRS

Congratulations! We successfully completed Gauge Report in SSRS.

2 thoughts on “Gauge Data Region in SSRS

Leave a Reply to Shital Cancel reply

Your email address will not be published. Required fields are marked *