Nested Lookup Functions? Need to match up two things RRS feed

  • General discussion

  • So I'm working in microsoft sql server report builder and here is essentially what I'm trying to do in code:

    (Under report variables)

    vChargeStatusID = Lookup(Fields!CREDIT_CARD_TRANSACTION_ID.Value, Parameters!CREDIT_CARD_TRANSACTION_ID.Value, Fields!CHARGE_STATUS_ID.Value, "DataSet1")

    (As an expression for a filter)

    Lookup(Variables!vChargeStatusID.Value, Fields!CHARGE_STATUS_FK.Value, Fields!CONTRACT_NUMBER.Value, "DataSet1")

    I've tried using the variable and the expression for the variable to try to create another calculated field, but no luck. I keep getting the error that I can't use nested lookup functions.

    Basically what I'm trying to do is, first, find two things that are equal to each other to retrieve a number. Then I need to take that number and match it to something else to finally return the contract number.

    I cannot figure this out.

    Any help would be great.

    Wednesday, March 6, 2013 9:15 PM

All replies