Hierarchial Grouping

[keg3]

Does anyone know if I create an hierarchial report (employee to supervisor) if there a way to indicate where to "start" the report? For example:

Manager 1
supervisor 1
employee A
employee B
supervisor 2
supervisor 3
employee C

I am using CR10 and want to start the display based on the person running the report. Supervisor 1 can only see their information and their employees information. Manager 1 could see all. The number of levels could be 0 to many.

Thanks

 

[synapsevampire]

Consider that this is based on the database, nobody can guess the layout of your tables reliably.

But the short answer is yes.

You could use the record selection formula to limit the rows to:

{table.parent_id} = {?parameter}
or
{table.child_id} = {?parameter}

I assume that you'd end up with a hierarchial relationship using a self join, so add in the table a second time and join the Parent ID to the Child ID.

-k