I have a requirement where I have to display User and Manager name on the report and the DB table is as follow:
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,