Display a image based on a value field

Hello friends
I have a problem displaying a picture on a table detail based on a value of
a column.
If this column have a value greather than 10, show a image, else show
another image. I don't know how to call the images on the statement below
=IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
I've added the images to the project as a embedded images.
Can anyone please help me or give me an example?
Thanks for Help
BrunoI only know one line of VB code, which is what I use to show/hide
report elements. Maybe you can use it to help you write yours to work
the way it needs to.
=IIF(Parameters!ReportGroup.Value = 1 AND Parameters!ReportType.Value =1, False, True)|||Hi Bruno
I'm only a novice, but this works:
Create two identical table rows, one below the other, each row has one cell
showing the (same) database field - e.g. "ID" and one cell to hold the
appropriate image - row 1 holds image1, row2 holds image2.
Now set the visibility of each row using expressions:
row1: =iif(Fields!ID.value<10,true,false)
row2: =iif(Fields!ID.value>=10,true,false)
when you run the report, the rows will be visible with the appropriate
images appearing as the ID.values change
~grasshopper~
"Bruno" wrote:
> Hello friends
> I have a problem displaying a picture on a table detail based on a value of
> a column.
> If this column have a value greather than 10, show a image, else show
> another image. I don't know how to call the images on the statement below
> =IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
> I've added the images to the project as a embedded images.
> Can anyone please help me or give me an example?
> Thanks for Help
> Bruno|||Create an image control on the report, make it show one of the images
you've embedded. In the properties of the image, you should be able to
see how the image is referred to in the "value" property. Now wrap the
=IIf statement around this. The image name will have to be in double
quotes because you are passing a string value to the property. For
example;
=IIf(Fields!DIAS.Value > 10, "Image1.gif", "Image2.gif")
If you wanted to show now image you could do;
=IIf(Fields!DIAS.Value > 10, Nothing, "Image2.bmp")
I haven't tried this but see no reason it shouldn't work for both
RS2000 or RS2005.
Cheers
Chris
Bruno wrote:
> Hello friends
> I have a problem displaying a picture on a table detail based on a
> value of a column.
> If this column have a value greather than 10, show a image, else show
> another image. I don't know how to call the images on the statement
> below
> =IIf(Fields!DIAS.Value > 10, show_image_1, show_image_2)
> I've added the images to the project as a embedded images.
> Can anyone please help me or give me an example?
> Thanks for Help
> Bruno

Disappearing lines when rendering as an IMAGE

I found that lines/colors disappear starting from page 3 or 4 when rendering
report page by page in any IMAGE format (TIFF, Metafile, BMP)
When you render all pages at once into multipage TIFF - all lines/colors are
preserved.
It looks like bug to me.
I have SP1 installed and it did not fix the problemDoes it happen when you render single page starting from specific page?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"SD" <SD@.discussions.microsoft.com> wrote in message
news:9B722DF5-84A3-4D3D-8272-F5590C142C2E@.microsoft.com...
>I found that lines/colors disappear starting from page 3 or 4 when
>rendering
> report page by page in any IMAGE format (TIFF, Metafile, BMP)
> When you render all pages at once into multipage TIFF - all lines/colors
> are
> preserved.
> It looks like bug to me.
> I have SP1 installed and it did not fix the problem|||Yes. It happens when I render single page in any image format.
"Lev Semenets [MSFT]" wrote:
> Does it happen when you render single page starting from specific page?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "SD" <SD@.discussions.microsoft.com> wrote in message
> news:9B722DF5-84A3-4D3D-8272-F5590C142C2E@.microsoft.com...
> >I found that lines/colors disappear starting from page 3 or 4 when
> >rendering
> > report page by page in any IMAGE format (TIFF, Metafile, BMP)
> >
> > When you render all pages at once into multipage TIFF - all lines/colors
> > are
> > preserved.
> >
> > It looks like bug to me.
> > I have SP1 installed and it did not fix the problem
>
>

Disappearing lines when rendering as an IMAGE

I'm having some problems rendering reports as images. We've been using PDF
rendering in the past and had no problems. However, when we switched over to
IMAGE we noticed that in reports with grid type layouts, some of the lines in
the grid would be missing. For example, a grid starting on the second page
of a particular report looks fine there, but on the next page all of the
gridlines are gone. On the next page I get the same result, but the
gridlines begin to show up again halfway down the page (within the same
grid). Any thoughts?
ThanksCould you create a sample report that demonstrates the problem and post it
to the newsgroup? Please use an embedded image and use one of the sample
databases as a data source.
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Boese" <Boese@.discussions.microsoft.com> wrote in message
news:77FC51EB-5F6B-48BF-95CF-84D138362FDD@.microsoft.com...
> I'm having some problems rendering reports as images. We've been using
PDF
> rendering in the past and had no problems. However, when we switched over
to
> IMAGE we noticed that in reports with grid type layouts, some of the lines
in
> the grid would be missing. For example, a grid starting on the second
page
> of a particular report looks fine there, but on the next page all of the
> gridlines are gone. On the next page I get the same result, but the
> gridlines begin to show up again halfway down the page (within the same
> grid). Any thoughts?
> Thanks|||It would probably be useful if I remembered to inclued the link...
http://www.rose-hulman.edu/~boeseaw/|||Increasing the border width should solve this problem.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Boese" <Boese@.discussions.microsoft.com> wrote in message
news:8658F69E-CAF5-4F41-B925-38F6AC615618@.microsoft.com...
> It would probably be useful if I remembered to inclued the link...
> http://www.rose-hulman.edu/~boeseaw/