Tutorial Gateway

  • C
  • C#
  • Java
  • Python
  • SQL
  • MySQL
  • Js
  • BI Tools
    • Informatica
    • Talend
    • Tableau
    • Power BI
    • SSIS
    • SSRS
    • SSAS
    • MDX
    • R Tutorial
    • Alteryx
    • QlikView
  • More
    • C Programs
    • C++ Programs
    • Go Programs
    • Python Programs
    • Java Programs

Gauges in SSRS

by suresh

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.

If you observe the below screenshot, It was a regular Table report with Country Name, Sales, and Total Number of Orders columns.

Gauges in SSRS 1

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.

Please refer to the SSRS Table Report, Data Source, and Dataset articles to understand the creation of Data Source, Dataset, and Table report. In this SSRS example, 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]

In this example, we are selecting SSRS Simple Radial Gauges.

Gauges in SSRS 2

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.

Gauges in SSRS 3

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.

Gauges in SSRS 4

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.

Gauges in SSRS 5

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

Gauges in SSRS 6

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.

Gauges in SSRS 7

Next, we have to configure the range properties by right-clicking on the range and selecting Range Properties.. option

Gauges in SSRS 8

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.
Gauges in SSRS 9

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.

Gauges in SSRS 10

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.

Gauges in SSRS 11

Placed Under: SSRS

  • Learn SSRS in 28 Days
  • Create New SSRS Project
  • Create a New SSRS Report
  • SSRS Query Designer
  • SSRS Shared Data Source
  • SSRS Shared Dataset
  • SSRS Embedded Dataset
  • SSRS Embedded Data Source
  • SSRS Lookup – combine datasets
  • SSRS Report Items
  • SSRS Table Report
  • SSRS Table using report wizard
  • Format SSRS Table Report
  • SSRS Matrix Report
  • SSRS Matrix with report wizard
  • Display Image in SSRS Report
  • Add Rectangle to SSRS Report
  • Add TextBox to SSRS Report
  • Create a SSRS List Report
  • Grouping in SSRS Matrix Reports
  • Grouping in SSRS Table Reports
  • Create SSRS Report using Views
  • SSRS report with store procedure
  • Add Total and Subtotal to Report
  • Add Headers & Footers to Report
  • SSRS Global References
  • Export Report to PDF, XML, Excel, Word
  • Format SSRS Table Report
  • Format Textbox Fonts & Bg Color
  • Format Numbers in SSRS Report
  • Format SSRS Report Date, Time
  • Add Row Numbers to Report
  • Headers Visible While Scrolling
  • Repeat Headers on Each Page
  • SSRS Sorting
  • SSRS Interactive Sort
  • Filters at Dataset Level in SSRS
  • Filters at Tablix Level in SSRS
  • Page Breaks in SSRS Report
  • Custom Code in SSRS Report
  • SSRS Calculated Fields
  • SSRS Dashboard Reports
  • SSRS Document Map
  • SSRS Drill Through Reports
  • SSRS Drill Down Reports
  • SSRS Drill Down Matrix Report
  • SSRS Go To URL Action
  • SSRS Subreports
  • SSRS Report Parameters
  • SSRS Cascading Parameters
  • SSRS Multiple Parameters
  • SSRS Multi Value Parameter
  • SSRS Drop Down List Parameters
  • SSRS Charts
  • SSRS Area Chart
  • SSRS Bubble Chart
  • SSRS Column Chart
  • Format SSRS Column Chart
  • SSRS Data Bars
  • Data Bars in SSRS Matrix Reports
  • Format SSRS Data Bars
  • SSRS Funnel Chart
  • SSRS Linear Gauges
  • SSRS Radial Gauges
  • Format SSRS Gauges
  • SSRS Indicators
  • Format SSRS Indicators
  • SSRS Line Chart
  • SSRS Pie Chart
  • Format SSRS Pie Chart
  • SSRS Pyramid Chart
  • SSRS Range Chart
  • SSRS Radar Chart
  • SSRS Scatter Plot
  • SSRS Sparkline
  • SSRS Stacked Bar Chart
  • SSRS Configuration Manager
  • Change Report Manager Title
  • SSRS Deploying Reports in BIDS
  • Deploy using Report Manager
  • SSRS Report Manager Shared DataSource
  • SSRS Cached Reports
  • SSRS Linked Reports
  • SSRS Report Parts
  • SSRS Report Snapshot
  • SSRS Report History Snapshot
  • SSRS Report Subscription
  • SSRS Security
  • Upload File to Report Manager
  • Install SSRS Report builder
  • Report Builder – Create a Report
  • Report Builder – Create a Dataset
  • Report Builder- Create Bar chart
  • Report Builder – Create Pie Chart
  • Report Builder – Create report without wizard

Copyright © 2021 · All Rights Reserved by Suresh

About Us | Contact Us | Privacy Policy