Click here to Skip to main content
15,894,405 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a report which use two data sets (dsdtl,dsopbal) and i use lookup function to get value from dsopbal, expression is
C#
=Lookup(Fields!FKCOA.Value,Fields!FKCOA.Value,Fields!OPBAL.Value,"dsopbal")
This report works correctly in vs report viewer, i am using SQL Server Business Intelligence Development Studio for server 2008 R2. Now when i render this report in my application it generate following exception

The Value expression for the text box ‘Textbox3’ refers to the field ‘OPBAL’. Report item expressions can only refer to fields within the current dataset scope or, if inside an aggregate, the specified dataset scope.<br />

Textbox3 contains the above expression.

Thanks
Posted

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900