iif help please...

I want textbox2 value to NOT show if textbox1 has the word "***mail***"
<--just like that between the quotes.
Any help is appreciated.
Thanks,
TrintTrint,
Right click on textbox2, go to select properties, click the advanced button,
then select the visibility tab. click the 'Expression' radio button, then
put this text in the text box for the expression:
=IIF(Fields!FieldForTextBox1.Value.ToString() = "***mail***", False, True)
Fields!FieldForTextBox1 is whatever field from your datasource is populating
textbox1.
That sound do it for you.
"trint" wrote:
> I want textbox2 value to NOT show if textbox1 has the word "***mail***"
> <--just like that between the quotes.
> Any help is appreciated.
> Thanks,
> Trint
>|||That is it Jeff!
Thanks!
Trint|||no problem.
"trint" wrote:
> That is it Jeff!
> Thanks!
> Trint
>

IIF expression problem

Hello all,

If anyone could give me a hand on this it would be greatly appreciated. The problem i am having is as follows: On a rdlc report I have a column which I am generating a currency value based on a nested IIF statement. What is happening is if I don't have the if statement for the column and just calculate like so : =Fields!Amount.value * 0.02 the number comes out correctly, however if I have it in the following iif statement it automatically rounds the values.

=FormatCurrency(IIF(Fields!Amount.Value = 114.00,((Fields!Amount.Value * .02)* 2),0)Or

IIF(Fields!Amount.Value = 20.00,((Fields!Amount.Value * .02) * 12),0)Or

IIF(Fields!Amount.Value = 216.00,(Fields!Amount.Value * .02),0))

Any insight would be great

Thanks

whats the datatype of Fields!Amount.value ... is it an integer or decimal