all groups > sql server reporting services > august 2005 >
You're in the

sql server reporting services

group:

Image And Expression



Image And Expression Angela
8/3/2005 6:45:01 PM
sql server reporting services: hi there,
i using an expression at the data value with the IIF statement to call the
image which i have embeded 2 images and wanna to display them on the table
textbox when they they satify the IIF statement. and i encounter this error;
The value expression for the image ‘image6’ contains an error: [BC30451] Name
'check' is not declared.
how can i resolve this problem or is there any other alternative for mi to
this issue.because wat i want is that within the IIF statement i wan to
display the different image.

thanks in advance
Angela
RE: Image And Expression Antoon
8/4/2005 4:01:03 AM
can you post the expression

[quoted text, click to view]
RE: Image And Expression Angela
8/4/2005 6:53:38 PM
=iif( First(Fields!allergyRoute_CODE.Value, "DataSet1") = Fields!Code.Value ,
check , checked )

(the image name is check and checked)

[quoted text, click to view]
RE: Image And Expression Antoon
8/5/2005 12:06:25 AM
ok,
- The name of the image has to be between quotes.
- You can not put this in a textbox, you can put the expression in an
image-box. So first put an image-box on you report (or in a table cell) and
than change the value of the image to the expression.
- In the expression you've given the Code-value of each row of the table is
compared to the "First" allergyRout_Code-value. This migth be correct, but if
you want to check against every value of allergyRout_Code, you should ommit
the "First"- function (if they are in the same dataset)
=iif( Fields!allergyRoute_CODE.Value = Fields!Code.Value ,
"check" , "checked" )


[quoted text, click to view]
RE: Image And Expression Angela
8/5/2005 12:51:02 AM
hi Antoon,

for the value to compare, they are from 2 different dataset. bcause i want
to compare the actual value with the master values. so if the answer matches
then i will display the correct image. And is there another other way apart
from making them to be the same dataset?

ur regards
Angela

[quoted text, click to view]
RE: Image And Expression Antoon
8/5/2005 1:51:09 AM
Yes there are, but if you really wan't to compare
First(Fields!allergyRoute_CODE.Value, "DataSet1") = Fields!Code.Value
then
=iif( First(Fields!allergyRoute_CODE.Value, "DataSet1") = Fields!Code.Value ,
"check" , "checked" )
should work fine (in an image-box-in-a-table-field)

[quoted text, click to view]
AddThis Social Bookmark Button