In this article we will show you, How to create and configure the Gauges in SQL Server Reporting Services 2014. For this, We are going to use below shown report. Please refer 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 normal Table report with Country Name, Sales and Total Number of Orders columns.
,SUM ([OrderQuantity])AS ORDERS
,SUM ([SalesAmount])AS [TOTAL SALES]
INNER JOIN FactInternetSales ON
[DimSalesTerritory].SalesTerritoryKey = FactInternetSales.SalesTerritoryKey
GROUP BY [SalesTerritoryCountry]
ORDER BY [SalesTerritoryCountry]
Creating Gauges in SSRS 2014
In this example, We will create and add the 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 Right option.
Next, Drag and drop the Drop the Gauges from Toolbox to Empty column. When you drag and Drop the Gauges from Toolbox to 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 Radial Gauges as shown in below screenshot.
Click Ok to add Radial Gauge to 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.
NOTE: Please be careful when dragging the columns to values region, if you mishandled or dropped in design area will end up in mess.
Next we have to configure the Scale Properties of a Gauge so, Right Click on the Scale will open the context menu. Please select the Scale Properties option from it.
Once you select the Scale Properties option, a new window will be opened to configure the 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 maximum value to 25000. You also use the fx button for custom expressions.
NOTE: You can also customize the intervals between Minimum and Maximum value using the Interval property.
Click Ok to finish configuring the Radial Gauge properties. Lets see the Report preview by clicking on preview tab
We successfully created the basic Radial Gauge
Adding Range to Gauges in SSRS 2014
If you observe the speed meter of a Car or Bike, you can see the Green, Red and Default White colors inside the Radial Gauge and each color has the meaning. If you want to apply the same in SSRS Reports then you can use the Range property in gauges.
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 below screenshot.
Next, we have to configure the range properties by right clicking on the range and selecting Range Properties.. option
Once you select the Range Properties.. option, a new window called Radial Scale Range Properties will be opened to configure the Range scale.
- 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 range will End at 5000 but you can change as per the requirements.
- Placement relative to scale: Here you have to decide whether you want to place the range inside the scale or outside the scale or across the scale.
- Start width: Range width at the starting position. By default 15 but you can change as per the requirements.
- End width: Range width at the ending position. By default 30 but you can change as per the requirements.
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. Lets see the Report preview by clicking on preview tab
Thank you For Visiting Our Blog