Report using project name

I am trying to set up a report that shows for a project who is working on which work items. In the query builder, I am able to find almost all the fields I need. Only the project part is still unclear.
I found the field AreaID which seems to relate to the project name. But, where do I find the project name. In the CurrituckDB I can't a find a table with both the AreaID and ProjectName.
COuld somebody point me in the right direction?
[447 byte] By [thys] at [2007-12-16]
# 1
Try to select System.TeamProject column from the WorkitemsAreLatest UDF (caution I'm looking at my dev box and not a beta2 deployment). Let me know if that works - if not, I'll dig up the query tomorrow.

thx

BryanMacFarlaneMSFT at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...
# 2
Thanks for your reply.
I can't find a column named System.TeamProject nor a column TeamProject. I looked in WorkitemsAre and in WorkitemsLatest.
thys at 2007-9-9 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - General...

Visual Studio Team System

Site Classified