Not all levels are showed

[Texaner]

The following problem:
I have a View, which provides this data:
- ProjektID
- ParentProjektID
- project name
- project manager
- project budget
There is always a big main project. You can identify the main project by value "NULL" in the column "ParentProjektID".
Such a project contains partial projects AND a partial project also again a partial project and so on till the n - level down (we are assuming that there are 10 levels).
However, a partial project has not necessarily the same project manager like the higher project or the main project.
All projects should be grouped according to the project managers of the main projects.
The issue would look as follows:
- name of the project manager
-----main project
-----------partial project
-----------partial project
-----------partial project
-----------------partial project
----main project
- name of the project manager
and so on

With an subreport I only reach up to the second project-level, because I group it according to the project manager and a further time according to main projects. After this I connect it with the subreport and I get the partial projects.

But only the partial projects of the main project are indicated to me, because I connect it with its ID.
As a result: all following levels are missing.
The hierarchical grouping does not help me.

What is the solution for showing all levels?
Are there any recursive functions in CR9?
Is it necessary to do it with already stored procedures on the SQL-server?

How I solve it now best which are indicated all levels. There are with CR9 recursive functions? Must or I do all that already with stored procedures on the SQL-server?

About suggested solutions or still better examples
I would be very grateful.
I hope I have expressed myself understandably (German with bad english ;-)).

 

[SmpTraining]

I'm not sure I understand your problem fully but have you looked into the 'heirachical grouping' options? If not, look it up and see whether it helps you out.

Steve Phillips, Crystal Consultant

 

[Texaner]

The problem is that the report has to be grouped by the following criterions: the project manager and his main projects.
It is possible that the main project contains one or more sub projects. And it is also possible that these sub projects contain further sub projects.

Possibly these sub projects are assigned to a different project manager as the main project. Because of this these sub projects are not showed.
That's wrong!

Irrespective of the project manager I need to see all sub projects including all levels.

The only important criterion is the project manager on the first level, means main project. This is the beginning.