Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

[rsLookupOfInvalidExpressionDataType] !!? Expand / Collapse
Author
Message
Posted Monday, October 08, 2012 4:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:56 AM
Points: 178, Visits: 668

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
Post #1369704
Posted Monday, October 08, 2012 6:47 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, December 19, 2013 10:40 PM
Points: 116, Visits: 395
Hi,
See this link might be helpfull to you
http://www.bi-rootdata.com/2012/10/lookup-function-in-ssrs.html
Post #1369779
Posted Tuesday, October 09, 2012 6:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, January 07, 2014 2:21 PM
Points: 132, Visits: 557
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
Post #1370345
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse