Search code examples
crystal-reports

How to lookup a column value in another column and display a different column

I am using Crystal Reports. In our tables we have members and clients. Members refer clients to our business. I am trying to display the customer name, and if they have a referring member display the referring members customer name as well. Since they are in the same table how can I do this?

In the scenario below Jake is the client with Mike being the referring member. The sequence number and referring member columns tie them together.

Seq Number --- Customer Name ---------Referring Member

4356 -----------------Mike ----------------------------- 0

7286 ---------------- Jake -------------------------- 4356

enter image description here

Solution

  • In Crystal, Database Expert, bring in the Customer Table table into the report a second time. Give it an Alias of "Member". Join the Customer table to the "Member" table on Customer.Referring Member = Member.Seq Number.