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 an Indicator

We use an indicator to gauge something against a set standard. Let's say that sales amounting to 75 percent of the target quota at a certain point in time is a good indicator of a good sales performance.

Let's add an indicator to the gauge report we created previously. If you don't want to mess with that, just copy that RDL file into a new report and modify that instead.

Let's add a new column to the right of the gauge column. Adjust all the columns appropriately. When the Select Indicator Type dialog box is displayed, select the 3 arrows (colored) directional indicator:

Adding an Indicator

Select and right-click on the Indicator, then select Indicator ...

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