Skip to Content
Former Member
Jul 29, 2009 at 01:28 PM

Report Design with Self Join



I have a requirement where I have to display User and Manager name on the report and the DB table is as follow:

Usr Id

Mgr Id

First Nm

Last Nm

I have created a report based on this table. I know we need to have a self-join to display the Manager name based on the above col's from single table.

I could do this at SQL end and get the data. I'm looking at how to get the Manager Name in Crystal Reports with single table.

Is there anyway we can achieve this without going with the Command option?

I'm totally new to CR and working on CR 2008Any suggestions are of great help.

Thanks in advace,