Home Forums Reporting Services Reporting Services 2008 Development Null Date Parameter, IIf condition generates runtime error. RE: Null Date Parameter, IIf condition generates runtime error.

  • July 7, 2014 at 8:07 am

    #1727376

    Try something like this

    =IIf(IsNothing(Parameters!MinimumSaleDate.Value), "", "Products Sold Since " & IIf(IsNothing(Parameters!MinimumSaleDate.Value), "", Parameters!MinimumSaleDate.Value.ToString))

    I know this looks daft but it evaluates all of the code regardless - So even though your code should work it's trying to set nothing to string

    So If you use an IIf even though it will never be used it should work

    Hope that makes sense

    Cheers

    Andy