Replace value with image

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?
Thank you!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
"Paul Havel" <PaulHavel@.discussions.microsoft.com> wrote in message
news:28C27E9A-FA4E-47DD-B3D8-E47A41517539@.microsoft.com...
> 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?
> Thank you!|||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!
"Sumit Pilankar" wrote:
> 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
>
> "Paul Havel" <PaulHavel@.discussions.microsoft.com> wrote in message
> news:28C27E9A-FA4E-47DD-B3D8-E47A41517539@.microsoft.com...
> > 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?
> >
> > Thank you!
>
>