• All the sites I'm seeing show that the conditional variable, if characters, needs to be in quotes.

    =iif(Fields!COSTYPE.Value = "M","Available","Reconciled")

    looks like the right syntax.

    (not an ssrs expert)

    perhaps it's a data type error, hence the error for "M" and not numbers. maybe convert the field before evaluation?

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.