Heirarchy Levels

[vummadis]

This question is about reporting a Organization Heirarchy. I have 4 columns in the Database Table.
1. Employee Id  2. Employee Name 3. Employee Level & 4. Employee Supervisor

I need to provide Promts to search on the 'Employee Id' field. The second Prompt will be on the field  'Employee Level'.
After I select these two prompts, my report should display the Heirarchy for that  employee (Who is supervisor for some employees).
It should display all the employees reporting to that manager. Also the count of employees reporting that Supervisor.

Note : Each employee has a supervisor.
1. Employee Id  2. Employee Name 3. Employee Level  4. Employee Supervisor

The solution is highly importent for me. Please respond at the earliest. Thankyou for looking into this.

[MFGF]

This question is about reporting a Organization Heirarchy. I have 4 columns in the Database Table.
1. Employee Id  2. Employee Name 3. Employee Level & 4. Employee Supervisor

I need to provide Promts to search on the 'Employee Id' field. The second Prompt will be on the field  'Employee Level'.
After I select these two prompts, my report should display the Heirarchy for that  employee (Who is supervisor for some employees).
It should display all the employees reporting to that manager. Also the count of employees reporting that Supervisor.

Note : Each employee has a supervisor.
1. Employee Id  2. Employee Name 3. Employee Level  4. Employee Supervisor

The solution is highly importent for me. Please respond at the earliest. Thankyou for looking into this.

Hi,

It's not clear here what the purpose of the prompt for 'Employee Level' is. Once you have an employee from the first prompt, that employee can only exist at one level, correct? What is the second prompt for?

Once we know more about the requirement, you need to tell us what you have attempted so far, and what does and doesn't work. Which part are you struggling with?

MF.

[Lynn]

The solution is highly importent for me. Please respond at the earliest. Thankyou for looking into this.

Interestingly enough, I don't think people typically post questions and add that it is a trivial matter and not terribly important so please feel free to ignore or take a long time before responding ;)

I would also suggest that you review the forum etiquette post to help you get the best answers possible. You haven't mentioned if your package is relational or dimensional. You mention a database table, but does that mean you intend to write SQL in your report?

You also have not provided any examples that would help someone understand the nature of your data items and their relationships such as understanding if the supervisor column contains a name or an ID. This would be important to understand to successfully find the subordinates.