Lookup function not working (RS SP2)

Posted by Al Reyes on Stack Overflow See other posts from Stack Overflow or by Al Reyes
Published on 2011-01-05T15:50:16Z Indexed on 2011/01/05 15:53 UTC
Read the original article Hit count: 218

Filed under:

Hi,

I made the upgrade to SP2. I'm trying to use the Lookup function to link data from two different servers. I'm trying first a simple exercise linking data from two datasets from the same server, having one dataset with journals and the other with the account description. My Expression looks like this at a field on the table I have:

=Lookup(Fields!ACTINDX.Value,Fields!ACTINDX.Value,Fields!ACTDESCR.Value,"ACCTINFO")

I made sure of the names and using only uppercases for datasets and fields but I'm receiving the following message when I try to preview:

"An error occurred during local report processing. The definition of the report '/DETAIL' is invalid. The Value expression for the text box 'ACTINDX' refers to the field 'ACTDESCR'. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope".

I'll appreciate any suggestions.

Regards,

Al

© Stack Overflow or respective owner

Related posts about reporting-services