Counting just child projects

Last post 10-22-2008 4:31 AM by boskom. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

09-19-2008 6:14 AM

fladager
Joined on 08-02-2007
New England
Posts 40

Counting just child projects

Reply Contact

I'm trying to pull together a list (and count by time period and phase) of bottom-level projects. I see within the ARB schema that there's a PaarentProject element but I don't see a ChildProject element. What I'm looking for is a cout of all projects where there is no child projects.

Any options or clever ways to do this with just the ParentProject item?

Many thanks!

Darlene

10-17-2008 1:03 PM In reply to

fladager
Joined on 08-02-2007
New England
Posts 40

Re: Counting just child projects

Reply Contact

Hi Folks,

Just wondering if anyone out there has a way to identify whether a project has a child project. As I mentioned above, I need to be able to count the lowest level projects and ParentProject doesn't provide that info.

Thanks!

Darlene

Filed under: Reporting, reporting tips, ARB

10-22-2008 4:31 AM In reply to

boskom
Joined on 05-05-2008
Austria
Posts 8

Re: Counting just child projects

Reply Contact

I would say that you have to create 2 queries, "Parent" and "Child", first with "Project Name" field, second with "Project Name" and "Parent Project Name" field. Join them with "Project Name" and "Parent Project Name" as key and from result set you'll see which projects have no child projects.

Bosko Mirkic
Project Manager
Hypo Alpe-Adria-Bank International AG
Austria

Page 1 of 1 (3 items)