Post reply

SSRS 2008: IsNothing Expression when displaying different fields

  • December 6, 2012 at 2:08 am

    #265861

    Hi All,

    I'd like to display different fields/columns in a graph based on a parameter.

    If the parameter is Null I need to display this field: Fields!vchParentIncidentType.Value and if its not null i need to diaplay this field:Fields!vchIncidentType.Value

    I'm using the expression below but at the moment its just displaying this field: vchIncidentType.Value - even if there's no value supplied for the parameter(NULL)

    =IIF(ISNothing(Parameters!uidIncidentTypeId.Value), Fields!vchParentIncidentType.Value, Fields!vchIncidentType.Value)

    Please help with the correct expression to use.

    Kind Regards

    Teee

  • December 6, 2012 at 7:42 am

    #1566179

    Hi,

    Multi-valued parameters can't be NULL as far as I know, no value supplied gives a parameter value of blank rather than NULL.

    Try this expression:

    =iif(Join(Parameters!uidIncidentTypeId.Value) = "", Fields!vchParentIncidentType.Value, Fields!vchIncidentType.Value)

    Cheers

    Gaz

  • December 6, 2012 at 11:08 pm

    #1566445

    It works perfectly! Thank you so much. 🙂

  • December 7, 2012 at 2:55 am

    #1566523

    No problem!

Viewing 4 posts - 1 through 3 (of 3 total)

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