Specify an Image as a Pointer on a Gauge (Report Builder and SSRS)
The gauge contains three built-in styles that can be used to customize the appearance of the pointer. For a radial gauge, the built in styles are: Needle, Marker and Bar. For a linear gauge, the built-in styles are Marker, Bar, and Thermometer. If a unique pointer is required, the user can create and specify an image which can be used as a fully functional pointer.
When you are specifying an image for the pointer, your image must have the following specifications:
The origin of the pointer, or center of rotation, must be at the top of the image.
The end of the pointer must be pointing down.
Since the pointer is an irregular shape, you will need to specify a transparency color to hide the unnecessary portions of the image. Consider using a color that would not normally be shown on the gauge as the transparency color, since the colors specified will not appear on the gauge.
You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.
To specify an image as a pointer on the gauge
In Design view, click the pointer of the gauge.
(Optional) If no pointer exists on the gauge, right-click on the gauge and select Add Pointer. A pointer is added to the gauge.
Click the Insert tab on the ribbon and double-click the image icon. The Image Properties dialog box opens.
Add an image to your report. For more information, see Embed an Image in a Report (Report Builder and SSRS).
Open the Properties pane.
On the design surface, click on the pointer. The properties for the pointer are displayed in the Properties pane.
Expand the PointerImage node.
In Source, select Embedded from the drop-down list.
If your image is stored in the database or on the web, you can specify the appropriate option for this property. For more information, see Image Properties Dialog Box, General (Report Builder and SSRS).
In Value, select the name of your image from the drop-down list.
In TransparentColor, pick a color value that you want to remove from the image. This will create a seamless appearance for the pointer in the gauge.