OK, I'm tryihng to use the Lookup() function. Here's what I've got in the expression:
=Lookup(First(Fields!Gender.Value, "RfsDataSet"), First(Fields!Gender.Value, "GenderDataSet"), First(Fields!GenderDesc.Value, "GenderDataSet"), "GenderDataSet")
When I compile the application I get the following error message:
The Value expression for the text box ‘Gender’ refers to the field ‘Gender’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.
RfsDataSet is the dataset associated with the query (a stored procedure in this case).
GenderDataSet is the dataset associated with the lookup table.
I'm not sure why I'm getting the error that I am. Where have I gone wrong?
Kindest Regards, Rod Connect with me on LinkedIn.