Jump to content

Reporting - Project Manager


Recommended Posts

Afternoon All

Hope you are safe and well.  I may be missing something very simple, I am trying to create a report using 3 tables however I am unable to link the third table.  I am currently using the 'Projects' table and the 'Project Tasks' table linking with a Left Join and by the Project ID.  However I need to be able to include in the report the project managers name so was trying to link the table 'h_sys_accounts' but keep getting error messages.  Please would it be possible for some help?  Thank you.

Kind Regards

Ann

Link to post
Share on other sites

@Ann

37 minutes ago, Ann said:

I am currently using the 'Projects' table and the 'Project Tasks' table linking with a Left Join and by the Project ID.

Why LEFT JOIN and not (normal) JOIN?

37 minutes ago, Ann said:

so was trying to link the table 'h_sys_accounts' but keep getting error messages.

Can you please post a screenshot of how is this configured in your report?

Link to post
Share on other sites

Afternoon @Victor

Hope you are well and had a lovely weekend.  I have tried the report with a (normal) JOIN between the tables but am still unable to link the h_sys_accounts table.  It may be something very simple that I am missing but I am unable to find the same column in h_sys_accounts to what is in Projects and Project Tasks.  We have a several reports that we really need the project managers name to display for.

Please find attached a screen shot of how I have the report set up.  Thank you.

Kind Regards

Ann

image.thumb.png.f1e56107bd1389ea8cfacd5acbcb3789.png

Link to post
Share on other sites

Afternoon @Victor

Hope you are well.  Please would it be possible for an update on the above query?  Sorry this is something that is causing quite an over head for us at the moment.  

I have tried to join the tables with a normal join and I have tried to link just the Projects and h_sys_accounts table but don't know which column to use.

Kind Regards

Ann

Link to post
Share on other sites

@Ann You might need to engage with Expert Services for this one.

As far as I'm aware, the Project Manager isn't recorded in the Projects table, so you'd need to extract the PM from the Project Members table (although looking at that data you can have more than one member with the PM role per project) and then use that information to link to the Users table to gather the User's name.

As you can see this will take a deeper understanding of the tables and relationships than I have, so if there is an urgency to creating this report I'd have to suggest Expert Services.

If the report is a "Nice to have" then I'm sure the answers will be forthcoming as other commitments allow.

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...