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

Linear Gauges in SSRS

In this article, we will show you how to create and configure the Linear 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 Number of Orders columns.

LINEAR GAUGES IN SSRS 2014

Please refer to the SSRS Table Report, Data Source, and Dataset articles to understand the creation of Data Source, Dataset, and Table report. Here, we used the Embedded Dataset for the above SSRS report, and the SQL Command for the Dataset is:

-- Data to create Linear Gauge 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]

Creating Linear Gauges in SSRS

In this example, We will create and add the SSRS Linear 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 the Empty column. When you drag and Drop the Gauges from Toolbox to the 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 Simple Linear Gauges, as shown in the below screenshot.

LINEAR GAUGES IN SSRS 2014

Click Ok to add Linear Gauge to a newly created empty cell. Now, we have to configure the Gauges Data. First, click on the Linear Gauge will open the Gauge Data window. In this example, we want to show the Linear Pointer for Total Sales so, Please drag and drop or select the orders as the Indicator Value.

LINEAR GAUGES IN SSRS 2014

NOTE: Please be careful when dragging the columns to values region, if you mishandled or dropped in the design area will end up in a mess.

Range Properties in Linear Gauges in SSRS

If you observe the above screenshot, Range is starting at 60 (Middle of the Scale) and end at 100. Let us make it more meaningful by Right Click on the Range will open the context menu. Please select the Range Properties.. option from it as shown in the below screenshot.

To add the Range, Please refer to Adding the Ranges section in Gauges in the SSRS article.

LINEAR GAUGES IN SSRS 2014

Once you select the Range Properties.. option, a new window called Linear Scale Range Properties will be opened to configure the Range scale. We have already explained the properties and their Default values of a Range in Gauges article.

Here, we kept the starting position to 0 and are changing the end position to Sum (Total Sales). It means Range will start at 0 and finish at Sum of Total Sales of each Territory.

LINEAR GAUGES IN SSRS 2014

SSRS Linear Gauge Scale Properties

Next, we have to configure the Scale Properties of a Linear Gauge in SSRS. So, Right Click on the Scale will open the context menu. Please select the Scale Properties option from it.

LINEAR GAUGES IN SSRS 2014

Once you choose the Scale Properties option, a new window will be opened to configure the SSRS Linear Gauge Scale. From the General tab, you can notice the default Minimum and Maximum values of a Linear gauge scale.

Here, we are changing the minimum value to 1500000 and maximum value to 9500000 because our values are between these two values. You also use the fx button for custom expressions.

LINEAR GAUGES IN SSRS 2014

NOTE: You can also customize the intervals between Minimum and Maximum value using the Interval property.

Next, We formatted the Number to currency, removed the decimal values, and asked the reporting server to display values in thousands. It means 1500000 will show as $1500

LINEAR GAUGES IN SSRS 2014

Click Ok to finish configuring the SSRS Linear gauge properties. Let’s see the Report preview by clicking on the preview tab

LINEAR GAUGES IN SSRS 2014

If you observe the above screenshot, It is giving a perfect result, but the range is starting beyond the starting point (1500000).

It is because we set the Range Starting value to 0 at the beginning. Let us change the range starting value to 1500000 as shown below

LINEAR GAUGES IN SSRS 2014

Click Ok to finish and click on the preview tab to see the SSRS Linear Gauges report

LINEAR GAUGES IN SSRS 2014

If you observe the above screenshot, It looks neat and clean.

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