There are 2 approaches: 1. Join SQL in your SQL Statement.
Select Employee.*, ReportingTo.EmpName as ReportingToName From Employee Inner Join Employee As ReportingTo On Employee.ReportingToId = ReportingTo.EmpId
2. Push the Join in to your report file.
That means, you design a report with 2 tables: Employee, ReportingTo (Alias of second Employee table), then you inner join them (Employee.ReportingToId -> ReportingTo.EmpId) in Database Experts -> Links.
Proposed as answer bySean ZhuMonday, November 03, 2008 10:30 PM