Is there an IN( ) function?

Is there and IN or and InList function in Reporting services? I'm trying to do some conditional formatting and it would be really handy to be able to write an expression such as =iif(Fields!blah.Value In(X,Y,Z),"Red","White")

Hi,

There is no IN function. I have been using OR functions for this

|||

Hi,

If your using RS 2005 then there is an IN function in Report Builder, just not in BIDS. I've used nested if statements to get around this problem when designing reports.

Cheers.

Dan.