A little help IIF

Hi all,
I have to rewrite a few reports from Cognos to Reporting Services. I was
hoping someone could help me with some of it. Does the "IN" work in reporting
services? The error code I get is [BC30455] Argument not specified for
parameter 'TruePart' of 'Public Function IIf(Expression As Boolean, TruePart
As Object, FalsePart As Object) As Object'.
I can not figure out what else it could be besides the IN. Is there something
else I can use?
=IIF( Fields!COST_ELEM_CTGY.Value ="G", "2G&AC",
(IIF( Fields!COST_ELEM_CTGY.Value IN "C", "P", "R", "V", "X"), "3OTHERS"),
(IIF( Parameters!WBSPrompt.Value = "W",
"1WBS")),
(IIF( Fields!COST_ELEM_CTGY.Value = "O" ,
"1OTHER",
"1FUNCTION")))
Thanks in Advanced,
Kerrie
--
Message posted via http://www.sqlmonster.comReporting service uses VB.net so the switch function or the choose
should work. Switch can be set up to return any object, Choose returns
an index. The msdn examples for these functions are:
Function MatchUp (CityName As String) As String
Return Microsoft.VisualBasic.Switch(CityName = "London", "English",
_
CityName = "Rome", "Italian", CityName = "Paris", "French")
End Function
Function GetChoice(Ind As Integer) As String
GetChoice = CStr(Choose(Ind, "Speedy", "United", "Federal"))
End Function