Skip to main content
Answer

Displaying project manager details in Report

  • October 20, 2023
  • 3 replies
  • 82 views

Forum|alt.badge.img+3

Hello Community,

I have been trying to display the contact details, like email of the project manager from Projects (PM301000) form.

I tried to use the join as PMProject to EPEmployee with Owner ID & Employee ID and then EPEmployee to Contact with Employee ID & Contact ID but the report throws up the error that it is not able to fetch the record. Can you please suggest me if I am using the correct joins ?

Best answer by dcomerford

@Harshita The Child Field should be CR.ContactID

3 replies

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • October 20, 2023

The Project Manager field on the Project is the OwnerID field and this will be your join to the Contact Table to get the detials you are after

 


Forum|alt.badge.img+3
  • Author
  • Captain II
  • October 20, 2023

The Project Manager field on the Project is the OwnerID field and this will be your join to the Contact Table to get the detials you are after

 

Hello @dcomerford ,

i used the following join, but still not displaying the email
 

 


dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • October 20, 2023

@Harshita The Child Field should be CR.ContactID