Click here to Skip to main content
15,887,676 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
HI,

Sql Reports: I have two data sets i want matching rows displayed i am using one report only two views common column is city
I used lookup =LookupSet(Fields!city.Value, Fields!city.Value, Fields!city.Value, "cityDATASET")

i am getting below error

An occurred during local processing the definition of the report'/Report2' is invalid
The value expression for the textbox 'Textbox2' has a scope parameter that is not valid for a lookup
function.The scope parameter must be set to a string constant that is the name of a dataset

Thanks in advance
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