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

Display a field onlt up to a Specific Character

Hi
Can someone please tell me if there is a function that can be used to print a field only up till a specific character. For ex: I'm trying to print all the student email Id's bu only the characters that fall before the "@." sign.
Thanks
ACleft(x, instr(x, '@.') -1)|||Hello
Thank you sooo much. It worked!!

Thanks again
Aparna

Display 2 field of database in form <select>

I have a database "code" with 2 field : "product_code" and "description".
product_code | description
PC | Personal Computer
MS | Mouse
etc

The form will let user choose a product code from this database. The query is like this :

java.sql.ResultSet rsproduct = statement10.executeQuery("SELECT * FROM code ORDER BY product_code");

At the form section,

<select name="product_code">
<option value=""></option>
<%
while(rsproduct.next()){
%>
<option value="<%=rsproduct.getString("product_code").trim()%>"><%=rsproduct.getString("product_code")%></option>
<%}%>
</select>

How should I coding if wanna let user view the description for particular product_code while scroll down?

Thanks~~Can any code for "pop up" the different description while the mouse pointer is on the different product_code?

DISCOVER_MEMORYUSAGE

The DISCOVER_MEMORYUSAGE command is not well documented. Any chance someone from the dev team could give a brief definition of each field you get in the results of this command?

I'm hoping for a definition so I can provide better documentation here (see the field definitions at the bottom):

http://www.codeplex.com/ASStoredProcedures/Wiki/View.aspx?title=MemoryUsage&referringTitle=Home

Thanks.

I was doing research on this recently and this is the information I gathered:

CanShrink - true if it can shrink (represented in perfmon counter Shrinkable, versus Unshrinkable)

MemoryUsed - bytes of memory used

MemoryAllocated - bytes of memory allocated

MemoryAllocBase - bytes for base (initial) allocation

MemoryAllocFromAlloc - this is for recursive definitions

Elements - count of elements

I hope this helps.

|||

Thanks for the info. I probably shouldn't have asked for "brief" definitions as I was hoping for a little more info. But those definitions are better than nothing!

Some other questions if you should feel so inclined to answer:

1. What's considered an "element"? Does this tie to count of members in a dimension? Count of rows in a partition? Count of attribute hierarchies in a dimension?

2. What are recursive definitions?

3. Would it be more accurate to say that for memory that's shrinkable, it's the MemoryUsed or the MemoryAllocated that can be shrunk?

4. Any general suggestions for things to look for when you're studying the results of DISCOVER_MEMORYUSAGE?

5. Any feedback on the MemoryUsage class would be welcome: http://www.codeplex.com/ASStoredProcedures/Wiki/View.aspx?title=MemoryUsage&referringTitle=Home

Disabling cache

One of the tables in my DB has a BLOB field that retrieved quite rare, so I
do not really need to have it in cache and would prefer to keep in the RAM
cache more useful data instead. Is it possible to disable caching of BLOB
values?
Message posted via http://www.droptable.com
Hi
There is no way to turn it off, but since it is rarely used, it will fall
out the cache very quickly as SQL Server is very good at tuning it's cache.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Alex via droptable.com" <no@.spam.pls> wrote in message
news:58af54c993dcc@.uwe...
> One of the tables in my DB has a BLOB field that retrieved quite rare, so
> I
> do not really need to have it in cache and would prefer to keep in the RAM
> cache more useful data instead. Is it possible to disable caching of BLOB
> values?
> --
> Message posted via http://www.droptable.com

Disabling cache

One of the tables in my DB has a BLOB field that retrieved quite rare, so I
do not really need to have it in cache and would prefer to keep in the RAM
cache more useful data instead. Is it possible to disable caching of BLOB
values?
--
Message posted via http://www.sqlmonster.comHi
There is no way to turn it off, but since it is rarely used, it will fall
out the cache very quickly as SQL Server is very good at tuning it's cache.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Alex via SQLMonster.com" <no@.spam.pls> wrote in message
news:58af54c993dcc@.uwe...
> One of the tables in my DB has a BLOB field that retrieved quite rare, so
> I
> do not really need to have it in cache and would prefer to keep in the RAM
> cache more useful data instead. Is it possible to disable caching of BLOB
> values?
> --
> Message posted via http://www.sqlmonster.com

Disabling cache

One of the tables in my DB has a BLOB field that retrieved quite rare, so I
do not really need to have it in cache and would prefer to keep in the RAM
cache more useful data instead. Is it possible to disable caching of BLOB
values?
Message posted via http://www.droptable.comHi
There is no way to turn it off, but since it is rarely used, it will fall
out the cache very quickly as SQL Server is very good at tuning it's cache.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Alex via droptable.com" <no@.spam.pls> wrote in message
news:58af54c993dcc@.uwe...
> One of the tables in my DB has a BLOB field that retrieved quite rare, so
> I
> do not really need to have it in cache and would prefer to keep in the RAM
> cache more useful data instead. Is it possible to disable caching of BLOB
> values?
> --
> Message posted via http://www.droptable.com