Is there ANY way to display "recurrent" data in Crystal?

I wonder if it is possible to somehow display self-recurrent data in Crystal reports.

Say, I have a "Department" table that contains link to itself. Since the department structure of a company can be complicated, I don't know how many levels of department will be in any "root" department. I want user to "drill in" via some kind of a tree until the final department level is reached. Ideally, it should be possible to display other data (such as names of employees) for each department.

I realize that each step down in department tree will require a separate SQL query to be sent to the server. And I also want the data to appear in the same window, just like an ordinary drill-down feature of Crystal. Is there any way to something like this via RDC and VB?

Thanks in advanceGroup it by DepartId and goto Report-->Hierarchical Grouping Options and set the child