Post reply

expression in textbox for blank

  • May 30, 2012 at 6:35 pm

    #269648

    hi

    i need to check if the variable contains nothing there should be 0 value display in report.

    =iif(Variables!YearCurrentshort.Value = " " ,0 , Variables!YearCurrentshort.Value)

    i am getting error,

    how to check for blank value

  • May 30, 2012 at 7:39 pm

    #1494988

    riya_dave (5/30/2012)

    hi

    i need to check if the variable contains nothing there should be 0 value display in report.

    =iif(Variables!YearCurrentshort.Value = " " ,0 , Variables!YearCurrentshort.Value)

    i am getting error,

    how to check for blank value

    =iif(isNothing(Variables!YearCurrentshort.Value) = true, 0 , Variables!YearCurrentshort.Value)

    [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply