Hi there,
I have quite a large report. I have a personnel details table and then I have a management table.
In the management table there is a foregin key called intPersonnelID (this is the name of the persons manager)
I want to be able to print the personnel details on the report and print their manager name as well but the only think that i can use to print the manager name id the forgien key which is the ID of the manager. But when i drag and drop this field onto the report it prints the personnel name again (as expected i suppose) Is there a formula that I can write to grab the manager name from the personnel details table based on the id in the management table.
I am using Crystal 11 Developer Edition
Thanks and Regards
I have quite a large report. I have a personnel details table and then I have a management table.
In the management table there is a foregin key called intPersonnelID (this is the name of the persons manager)
I want to be able to print the personnel details on the report and print their manager name as well but the only think that i can use to print the manager name id the forgien key which is the ID of the manager. But when i drag and drop this field onto the report it prints the personnel name again (as expected i suppose) Is there a formula that I can write to grab the manager name from the personnel details table based on the id in the management table.
I am using Crystal 11 Developer Edition
Thanks and Regards