Area path Reporting hierarchy

I am trying to create this report for a high level hierarchy area path. But when i choose the high level one, all the lower level hierarchy areas follow and provide way more information in the report than i need.

Area1

|--Area2

| |Area3

| | |Area4

so what i am trying to say is that i dont want Area3 or Area4 when i want to report on Area2. and this is how my area path looks like and can not be changed. so is there hope. can i modify the query so as to exclue Area3 and Area4. Any help would be appreciated. thanks,

[559 byte] By [help_iman] at [2008-1-10]

Visual Studio Team System

Site Classified