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