Groups | Blog | Home
all groups > sql server reporting services > november 2005 >

sql server reporting services : Replace value with image


Paul Havel
11/28/2005 2:27:02 PM
Hello, I'm new to Reporting Services 2005, so I'm not sure if what I'm asking
is possible. What I need to do is replace a certain value in a report with
an image. For example, the values in a given column will either be -1, 0 or
1. What I need to do is replace that value with a specific graphic, based on
which value it is. Can anyone let me know how this could be done or if it's
even possible?

Sumit Pilankar
11/29/2005 5:29:37 PM
Hi,

You can do this by adding a conditional statement to the BackGroundImage
Property's value field

You can write
IIf(Fields!YourField.Value=-1,"Image-1",IIF(Fields!YourField.Value=0,"Image0",IIF(Fields!YourField.Value=1,"Image1","")

Let me know if this worked

Sumit Pilankar



[quoted text, click to view]

Paul Havel
11/30/2005 7:19:10 AM
Thanks for the response and getting me going in the right direction. What I
had to ultimately do was add an Image from the toolbox to the cell where I
wanted to display the graphics. Then in the properties for that cell, I
specified the Value as a conditional statement that displays a given graphic
based on the value of one of the columns in the query. Works as expected!
Thanks again!


[quoted text, click to view]
AddThis Social Bookmark Button