Hello,
I have an object that I consume for a Windows Forms Report in VS 2005. The Report displays all of the elements on the top level of the Object (FirstName, LastName, Phone, etc...) but when I attempt to pull items from one of the child objects, such as SkillName, VS.Net throws an error stating that:
Error 1 The Value expression for the textbox ‘SkillName’ refers to the field ‘SkillName’. Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope.
The structure of my object is as follows:
Person
|_ FirstName
|_ LastName
- PersonSkill
|_ SkillName
I want to show all of the Skills that a Person has under each person displayed in the report. Nothing that I have tried seems to work. Does anyone have any suggestions?
When I step through the code, on one particular query 65 Persons are returned with their child objects. I was hoping that I could just see the child objects without going through hoops...
I have struck similar issues as well. What I had to do was construct a dataset that contained all of the information I required. For you this will probably mean doing an outer join on the skills to get the entire list of skills for a particular person.
Craig
No comments:
Post a Comment