none
Lookup SSRS #Error issue RRS feed

  • Question

  • Hello,

    We're using Lookup (CInt(main_datatset.column1.joiningcolumn), CInt(second_dataset.column1.joiningcolumn), second_dataset.column2, "second_dataset_name.") keyword to pull column value from other data set under the same rdl file.

    But since some of the value doesn't exists/blank/NULL in second dataset report is displaying #Error, we want to change the display to blank/Unknown, but we're unable to change it. We tried using IsNothing() function but no luck.

    Any help would it be appreciated.

    Thank you in advance.

    Regards,

    gk03


    Please do let us know your feedback. Thank You - KG, MCTS

    Thursday, June 7, 2018 7:29 PM

All replies

  • Hi gk1393

    According to your description , seems that the issue is related to the conversion .

    Based on my research , if you convert “ ”(blank value) to int type , then “#ERROR” will occur .

    So , all you need to do is to justify the field is “ ”  (blank value) or not before you convert it. Expression like below:

    =Lookup(
    CInt(main_datatset.column1.joiningcolumn), 
    CInt( 
        Iif(  
    	   isNothing(second_dataset.column1.joiningcolumn) or Trim(second_dataset.column1.joiningcolumn) = ' ',
    	   0,
    	   CInt(second_dataset.column1.joiningcolumn) 
    	   ) 
    	), 
    second_dataset.column2, 
    "second_dataset_name."
    )


    You could also do the check for the first database field.

    Hope It can help you.

    Best Regards,

    Eric Liu


    Best Regards, Eric Liu MSDN Community Support Please remember to click Mark as Answer if 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.


    Friday, June 8, 2018 2:15 AM