O'Reilly logo

SQL Server 2012 Reporting Services Blueprints by Mickey Stuewe, Marlon Ribunal

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring the pointer of a gauge

Let's configure the pointer. Select the gauge pointer, then right-click on it. From its context menu, select Pointer Properties:

Configuring the pointer of a gauge

Set its value to [SUM(SalesYTD)].

Let's add another pointer. Select and right-click on the gauge itself, select Add Pointer from the context menu to add a secondary pointer. Set the value of the second pointer to [SUM(SalesLastYear)].

Change the color of our primary pointer, fill color to lime green and the secondary orange. What we want to achieve by the two pointers on the same gauge is compare the current sales with the previous sales value at the same point in time.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required