Showing posts with label based. Show all posts
Showing posts with label based. Show all posts

Monday, March 26, 2012

Reg SQL Svr Enterprise Edtn 2005 Win32 English MVL 1 Proc

Hi,

I have purchased

SQL Svr Enterprise Edtn 2005 Win32 English MVL 1 Proc does it mean that its 32 bit software? and its 1 processor based license ?

Also will it run on HP DL580 G4/(1) Dual-Core 64-bit Intel? Xeon? 7110M Processor (2.60 GHz, 95 Watts, 800MHz FSB) successfully ?

Pls reply urgently

Thanks

Yes, that is a 32 bit version, evidenced by the designation [ Win32 ].

Yes, it is single processor, evidenced by the designation [ 1 Proc ].

It will run on 32 or 64 bit Windows Server.

Friday, March 9, 2012

Reference Child Objects in a Report based on...Objects.

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