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

Adding a scale for the gauge

Now, select the scale (numbers in the gauge) and right-click on it to display its context menu. On the Radial Scale Properties dialog box, set its Maximum value to that of the [SUM(SalesQuota)]. Before you save and close the dialog box, format the number. Don't put decimal and show its value in Millions.

Adding a scale for the gauge

You probably get the idea of what the relationship is between the pointers (Sales YTD / Sales Last Year) and scale (SalesQuota). The pointer indicates how far or close the value (SalesYTD / Sales Last Year) is to its target or goal (SalesQuota).

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