Try this |
| Arvind Kumar replied to vamsi n at 03-Jul-08 01:28 |
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 properties 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 multiplying 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 )))
http://www.microsoft.com/technet/prodtechnol/sql/2005/technologies/rch7rptslnpatternrecipes.mspx |
|