Post reply

[rsLookupOfInvalidExpressionDataType] !!?

  • October 8, 2012 at 4:33 am

    #282709

    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

  • October 8, 2012 at 6:47 am

    #1546693

    Hi,

    See this link might be helpfull to you

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

  • October 9, 2012 at 6:04 am

    #1547176

    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