title: Crystal Reports: Hierarchical fields
body: <p>There is a table in my DB about the Departments of an Organization. This table has the Department_ID and the BasisDepartment_ID which is the ID of the "above"department. There is also another table with the above IDs and a field called Level that supposedly shows the level of the department with 0 being the bottom department and 4 the TOP. However for a level 3 I get all of the departments with level 0 to 3 when I do a SELECT statement.
  This is a bit of info to understand the DB.
  My problem is that I don't know how to implement the hierarchy in CR. I have been asked to make a report with 4 columns that describes the hierarchy of the departments an employee belongs to. Keep in mind that not all employees have to have 4 departments. A person could be the head of the department without belonging to it but to the department above.
  Thank you in advance for any help.</p>