I am trying to configure a query builder report based on the User table. Our user info pulls from LDAP and includes the user ID (name), Full Name, and supervisor. The supervisor value is actually the supervisor's user ID (Name attribute). I'd like be able to have the report show the Full Name of the user's supervisor rather than just the ID. In other words, I'd like to run the report from the Users table and evaluate the returned supervisor ID against the Users table again to have the Full Name returned. Is this possible? I've tried to clarify with an image mockup. I can't find anything that seems to do this... albeit I am fairly new to this. I have started going through the massive reporting document in this community but haven't found anything that helps in this case yet.
