locked
Using ISNothing along with Lookup function in SSRS RRS feed

  • Question

  • Hi All,

    I have two dataset in SSRS how to pick the the value based on the coleasce(ISNOTHING) function like if the second dataset value is null for the particular column then we need to pick and display the first dataset value else display the second dataset value.

    Thanks

    Vannikannan.K

    Thursday, October 24, 2019 2:55 PM

All replies

  • Hi Vannikannan,

    For this you need to combine iif and lookup function.

    IIF is for the judging if it is now, Lookup is used to choose the data from other dataset.

    It would be something like

     =iif(fields!A.value is nothing,Lookup(source_expression, destination_expression, result_expression, dataset), fields!A.value)

    Hope this helps.

    Regards,

    Lukas


    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Friday, October 25, 2019 2:18 AM