• I have few columns in my report.

    Email & Purchase date.. . In that email column & Purchase date some people don't have email Id. i..e My report shows some has values and some blank. I want to display null instead of blank (empty) and keep as it is for remaining.

    I need help

    =iif(Fields!name.Value="","Null",Fields!name.Value)

    I use that expression but it is showing error when there is value in the column.

    Help me out please. Correct me the wrong in the above expression