Report Solution Patterns and Recipes - Professional SQL Server 2005 Reporting Services - page 289

Figure 7-23

The Image items properties are set to use embedded images. I've set the image to FitProportional but
this may be changed depending on the image size and characteristics. I typically use the Padding prop-
erties to provide margin space around the image cell. The image item's Value property will tie each
row's sales quota value to a corresponding gauge.

A calculated column called PercentOfQuota returns a float value as a percentage (0.0 to 1.0). By multi-
plying this value and converting it to an integer, using the Visual Basic CInt() function, these values
now correspond to my image file names (0 to 10). This expression concatenates this integer with the rest
of the file name. To prevent an overflow condition, if the percentage value is greater than 1 (100%), the
expression always returns the highest value, 10.

=”t_guage” & IIF(Fields!PercentOfQuota.Value>1, “10”,
CStr(CInt(Fields!PercentOfQuota.Value * 10 )))

Here's the final result, shown in Figure 7-24.

I'll use the same basic principle in the next example to produce a business scorecard.

Creating a Business Scorecard
This type of reporting scenario has quickly become a mainstay in enterprise business applications. Also
known as executive dashboards, business scorecards provide summary level progress and success status
information for business leaders.

What you'll need:

❑ A query expression with data-based or calculated target, budget, variance, and actual values.

❑ A multi-group table with drill-down features.

❑ Small images for use as progress indicators.

❑ An expression used to translate KPI and target values to indicator images.