Lookup Returning Blank

• ttdeveloper

  SSCrazy

  Points: 2370

  More actions

  April 1, 2015 at 2:16 pm

  #302717

  This is driving me totally insane. Can anyone tell me what I am doing wrong here.

  Two datasets (AttainmentTotal,B) attached.

  SSRS tablix with expression in textbox as below

  =Lookup(Fields!MonthNm.Value, Fields!MonthNm.Value,

  Fields!AttainmentTotal.Value, "sp_NonData_Attainment_Total")

  Last column in design returns blank cell as though there is no match.

• ttdeveloper

  SSCrazy

  Points: 2370

  More actions

  April 2, 2015 at 12:49 pm

  #1788416

  Found a problem in my code.

  Syntax is correct for lookup. Dataset was not returning anything to SSRS renderer because I was passing the wrong parameters.

  Thanks