Replace value with image

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Havel - 28 Nov 2005 22:27 GMT

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!

Reply to this Message

Sumit Pilankar - 29 Nov 2005 11:53 GMT

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

> Hello, I'm new to Reporting Services 2005, so I'm not sure if what I'm
> asking
[quoted text clipped - 9 lines]
>
> Thank you!

Reply to this Message

Paul Havel - 30 Nov 2005 15:19 GMT

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!

> Hi,
>
[quoted text clipped - 21 lines]
> >
> > Thank you!

Reply to this Message