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!
>
>

replace funtion

how do i write a replace function that will replace a certain character with a return key (ie what happens when we do Ctrl+return key in SQL Enterprise table... so that the rest of the cell data in the column is on the next line?!

SELECT REPLACE(tasks, '/', '??') AS EXPR1
FROM log_descriptions

what should ?? be?I think you want the char function with the ascii code for line break.|||I alway forget the ANSII code for a line break so I use this instead:
SELECT REPLACE(tasks, '/', '
') AS EXPR1
FROM log_descriptions

Works like a charm :)|||or this, maybe easier to read in a big script :)

declare @.cr char(1)
set @.cr = '
'
select 'a' + @.cr + 'b'|||Char(13)+char(10)|||13 & 10... I'll try to rember that :D

So summing this up we got:
DECLARE @.cr CHAR(1)
SET @.cr = CHAR(13) + CHAR(10)
SELECT 'a' + @.cr + 'b'

repeatwith property

I have tried for days to get certain textboxes and tables in page body

to repeat on multiple page reports

Any help is appreciated.

Hello,

The repeatwith property is not available on tables and is not supported by physical paginated renderes.

However, the RepeateOnNewPage property of table&group headers and footers is supported by all renderers.

Thank you,

Nico

|||

How to transfer parameter to Header and display it on next page.

I reference one report textbox to header textbox "= ReportItems!textbox1.Value "

But it didn't display on second page....

What can I do?

|||

Hello,

Could you provide the rdl so I can understand what you are trying to achieve?

Thanks,

Nico

|||

How to use static query in my header textbox

= "SELECT [Contractor Name] FROM tblvendor WHERE vendorID=" & Parameters!vendorID.Value

It display the text "SELECT [Contractor Name] FROM tblvendor WHERE vendorID=354" not the query result