Tutorial Gateway

  • C
  • C#
  • Python
  • SQL
  • Java
  • 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
  • MySQL

Formatting Gauges in SSRS

In this article, we will show you how to Change the Gauge color, Gauge Frame, Gauge Pointers, and formatting Range properties in SSRS or SQL Server Reporting Services with an example.

To explain the available SSRS Gauges Format options, We are going to use below shown report. Please refer to Gauges in SSRS article to understand the Data Source and Dataset we used for this SSRS report.

FORMATTING GAUGES IN SSRS 2014

Formatting Gauges in SSRS Properties

First, Right-click on the Gauge will open the context menu, as shown in the below screenshot. Please select the Gauge Properties.. option from that menu

Formatting Gauges in SSRS 2014

Format SSRS Gauge color (Dial Color)

Once you click the Gauge Properties.. option, a new window will be opened to format the Radial Gauges. From the below screenshot, you can observe that, By default, Gauge filled with White Smoke color, but For now, we selected the white color. Please click on the fx button to write the custom expression for color.

Formatting Gauges in SSRS 2014

Format Gauge Shape in SSRS

Within the Radial Gauge Properties window, If you click on the Frame Tab, we have multiple shapes to choose as shown below. Here we stick to the default Circular 2, but you try your own.

Formatting Gauges in SSRS 2014

Format Frame Color of a Gauge

If you click on the Frame Fill Tab, we have the default Frame color, and please change SSRS Gauge frame as per your requirement. Here we are selecting Cornflower Blue color as Frame Color.

Formatting Gauges in SSRS 2014

If you want to set the shadow effects to the Gauge Frame, then please provide the details in Frame Shadow Tab

Formatting Gauges in SSRS 2014

Formatting Gauge Pointer in SSRS

First, Right-click on the Gauge Pointer opens the context menu as shown in the below screenshot. Please select the Pointer Properties.. option from that menu

Formatting Gauges in SSRS 2014

Changing Gauge Pointer

Once you click the Pointer Properties.. option, a new window will be opened to format the Radial Gauge Pointer. Please change the Pointer type and Needle style as per your requirement. In this example, We are changing the Needle Style to Stealth Arrow, as shown in below screenshot

Formatting Gauges in SSRS 2014

Format Pointer Color of a Gauge

Within the Radial Pointer Properties tab, If you click on the Pointer Fill Tab we have the default pointer color and Style, Please change as per your need.

Here we are selecting a Primary color to Blue and Secondary color to Cornflower Blue color.

Formatting Gauges in SSRS 2014

Format Pointer Cap of a Gauge

Within the Radial Pointer Properties tab, If you click on the Cap Options Tab, we have the options to Hide the Pointer Cap and change the default Cap Style, Please change accordingly. Here we are selecting Flattened with wide indentation as the Pointer Cap Style.

Formatting Gauges in SSRS 2014

Format Cap Color of a Gauge in SSRS

Within the Radial Pointer Properties tab, If you click on the Cap Fill Tab we have the default cap color, Please change as per your requirement. Here we are selecting Cornflower Blue color.

Formatting Gauges in SSRS 2014

Formatting Range Properties of a Gauge

First, Right-click on the Range and select the Range Properties.. option from it

Formatting Gauges in SSRS 2014

Format Range Colors of a Gauges in SSRS

Once you click the Range Properties.. option, a new window will be opened to format the Range of a Radial Gauge. First, goto Fill tab, you can notice the default colors and styles of a Range, Please change as per your requirement.

Here we are selecting a Primary color as Light Steel Blue and Secondary color to Cornflower Blue color as shown below screenshot.

Formatting Gauges in SSRS 2014

NOTE: By clicking the fx you can customize the colors using Expression

Format Range Borders in SSRS Gauges

Within the Radial Pointer Properties tab, If you click on the Border Tab, we have the default Line Style, Line Width, and Line Color. Here we are selecting Cornflower Blue color as Line Color, Width, as 2pt shown below.

Formatting Gauges in SSRS 2014

Format Scale Properties of a Gauge

First, Right-click on the Scale will open the context menu. Please select the Scale Properties.. option from it. Once you click the Scale Properties.. option, a new window will open to format the Scale of a Radial Gauge. 

First, go to the Labels tab, you notice the default configurations of a label. Here you can Hide or Show the labels and also change the positions etc.

Formatting Gauges in SSRS 2014

Changing Font Style and Font Size in Gauge in SSRS

Within the Radial Scale Properties window, goto Label Font tab and style the font as per your requirements. In this example, we are changing the Font to Lucida Sans, style to Bold and Color to Black

Formatting Gauges in SSRS 2014

Formatting Scale Numbers in SSRS Gauges

Within the Numbers Tab, you can change the Number format to Number or Currency or Percentage. In this example, we are removing extra decimals.

Formatting Gauges in SSRS 2014

Click Ok to finish formatting the Gauges. Let us see the report preview by clicking Preview tab.

Format SSRS Gauges

Filed 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 | Contact | Privacy Policy