[rsLookupOfInvalidExpressionDataType] !!?

  • Hi geniuses.

    I have a column in my report with an expression:

    =Lookup(Fields!ProjectGUID.Value,Fields!PROJ_UID.Value,Fields!STAGE_NAME.Value, "DataSet2")

    I'm not getting the right data.

    BIDS gives me a warning that says:

    The Value expression for the textrun ‘Textbox21.Paragraphs[0].TextRuns[0]’ uses a lookup function with an expression that returned a data type that is not valid for the lookup function. The data type must be an RDL Variant type.

    Any solutions?

    Thanks

    Regards

  • Hi,

    See this link might be helpfull to you

    http://www.bi-rootdata.com/2012/10/lookup-function-in-ssrs.html

  • davdam8 (10/8/2012)


    =Lookup(Fields!ProjectGUID.Value, Fields!PROJ_UID.Value, Fields!STAGE_NAME.Value, "DataSet2")

    I'm not getting the right data.

    BIDS gives me a warning that says:

    The Value expression for the textrun ‘Textbox21.Paragraphs[0].TextRuns[0]’ uses a lookup function with an expression that returned a data type that is not valid for the lookup function. The data type must be an RDL Variant type.

    The problem maybe of datatype mismatch. check the datatype of both the join fields.

    or maybe you need to try lookupSet function

    BI Developer
    SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
    Please visit... ApplyBI

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

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