In this article, we will show you how to create and configure the Gauges in SSRS. For this, We are going to use the below-shown report. Please refer to the SSRS Table Report, Data Source, and Dataset articles to understand the creation of Data Source, Dataset, and Table report.
If you observe the below screenshot, It was a regular Table report with Country Name, Sales, and Total Number of Orders columns.
We used the Embedded Dataset for the above report and the SQL Command we used as the Dataset is:
-- T-SQL Query required to demonstrate Gauges in SSRS
SELECT [SalesTerritoryCountry]
,SUM ([OrderQuantity])AS ORDERS
,SUM ([SalesAmount])AS [TOTAL SALES]
FROM [DimSalesTerritory]
INNER JOIN FactInternetSales ON
[DimSalesTerritory].SalesTerritoryKey = FactInternetSales.SalesTerritoryKey
GROUP BY [SalesTerritoryCountry]
ORDER BY [SalesTerritoryCountry]Create Gauges in SSRS
In this example, We will create and add the SSRS Gauges on the right-hand side of the Orders column. So, First, create an Empty column by right-clicking on the Orders column and select the Insert Column option and then select the Right option.
Next, Drag and drop the Gauges from Toolbox to an Empty column. When you drop the Gauges to an Empty column, a new window called Select Gauges Type will be opened to select required Gauges (Radial and Linear) from the available once.
In this example, we are selecting SSRS Simple Radial Gauges.
Click Ok to add Radial Gauge to a newly created empty cell. Now, we have to configure the Gauges value. First, Click on the Gauges will open the Gauge Data window.
In this example, we want to show the Radial Pointer for Orders. So, Please drag and drop or select the orders as the Indicator Value.
Next, we have to configure the Scale Properties of a Gauge in SSRS. So, Right Click on the Scale will open the context menu. Please select the Scale Properties option from it.
Once you choose the Scale Properties option, a new window will be opened to configure the SSRS Gauge Scale. From the General tab, you can notice the default Minimum and Maximum values of a Radial gauge scale.
By default, The Minimum and maximum values of the Radial Scale will be between 0 and 100. Here, we are leaving the minimum value to 0 and the maximum value to 25000. You also use the fx button for custom expressions.
NOTE: You can also customize the SSSR Gauges intervals between Minimum and Maximum value using the Interval property.
Click Ok to finish configuring the SSRS Radial Gauge properties. Let’s see the Report preview by clicking on the preview tab
We successfully created the basic Radial Gauge in SSRS
How to add Range to Gauges in SSRS
If you observe the speed meter of a Car or Bike, you can see the Green, Red, and Default White colors inside the SSRS Radial Gauge, and each color has the meaning. If you want to apply the same in the Reports, then you can use the Range property of gauges in SSRS.
To add the Range, Right Click on the Scale will open the context menu. Please select the Add Range option from it, as shown in the below screenshot.
Next, we have to configure the range properties by right-clicking on the range and selecting Range Properties.. option
Once you choose the Range Properties.. option, a new window called Radial Scale Range Properties will be opened to configure the Range scale of an SSRS gauge.
- Start range at Scale Value: Default value is 250, it means range will start at 250, but you can change as per the requirements.
- End range at Scale Value: By default 5000, it means SSRS Gauge range will End in 5000. Change as per the requirements.
- Placement relative to scale: Here, decide whether you want to place the range inside the scale, outside the scale, or across the scale.
- Start width: Range width at the starting position. By default, 15, but you can change accordingly.
- End width: Ending position Range width. By default, 30. Change as per your needs.
In this example, we changed the starting position to 0 and end position to Sum(Orders). It means Range will start at 0 and finish at Sum(Orders) value.
Click Ok to finish configuring the Range properties of a Radial range. Let’s see the SSRS Gauges Report preview by clicking on the preview tab.
