Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Expression not correct???

0 views
Skip to first unread message

Edgar

unread,
Dec 15, 2009, 10:52:01 AM12/15/09
to
Hi all,

I am fighting with an expression for the hidden property of some field on my
report.

These are my findings:

This works: = Fields!Name.Value > ""
This works: = iif(Fields!Name.Value > "", true, false)
This works: = (iif(Fields!Name.Value > "", true, false))
But this does not work:
= (Iif(Fields!Name.Value > "" OR Fields!Mailing.Value = "Y", true, false))

The error message I get is:
An error occurred during local report processing. The Hidden expression for
textbox 'City' contains an error: Input string was not in a corect format.

Is this a bug or am I doing something wrong?


--
Thanks,

Edgar

Mark_Seven

unread,
Dec 15, 2009, 1:29:35 PM12/15/09
to

Edgar,
You could try a nested if statement similar to:
= iif(Fields!Name.Value > "", true, iif(Fields!Mailing.Value = "Y",
true, false))

That usually works for me.
Also, you might want to watch out for NULL values

HTH, Mark

0 new messages