error in using the IFF statment

Hi,
I used=IFF( Fields!used.Value=False, 'Fields!s_Count.Value','0')in my column and it shows an error. The error is as below...


c:\projects\ics\report ics 1\Stock Balance Report.rdl The value expression for the textbox 's_Count' contains an error: [BC30451] Name 'IFF' is not declared.
What does it mean that the 'IFF' is not declared? Does anyone know why..?

Hi, u can easily write the iif Condition... I am giving some Examples.....
=IFF( Fields!used.Value=False, 'Fields!s_Count.Value','0') (ur Statement)
As
=IFF( Fields!used.Value=False,Fields!s_Count.Value,"0") "Write One" Note: Don't use single Quotes ...use Double Quotes...(just as vb syntax)
and Some Examples:
1) =iif(Fields!MainNo.Value is Nothing or Fields!MainNo.Value = "",Fields!SRNo.Value,Fields!MainNo.Value)
2) Switch: and If U Want to Check Multiple Conditions u can use like this....

=Switch(
ucase(First(Fields!priorityid.Value))="LM","Lunch Motion",
ucase(First(Fields!priorityid.Value))="M","Motion",
ucase(First(Fields!priorityid.Value))="O","Oridanry",ucase(First(Fields!priorityid.Value))="FLC","Fair List Cases",
ucase(First(Fields!priorityid.Value))="S","Supplemental")

ok......then u can check if u have still errors Mail Me....praveenk_dotnet@.yahoo.com
|||How about IIF ?