Post

2 followers Follow
0
Avatar

Can a report be created that uses Project task completion dates as well as custom fields from a project property card

I'm trying to create a report that contains a combination of task completion dates as well as dates that have been entered on a Porject property card.  What is the best way to accomplish this? 

Jon Benusa Answered

Please sign in to leave a comment.

3 comments

0
Avatar

When you create your report, you have to declare what you are reporting on (So in your case most likely you would report on the Project) you then have the option to add related data using the boxes to the right.  Add tasks as a related data table and you should now be able to include both project properties data and also to access project task data also.

Phil Smith 0 votes
0
Avatar

Phil - I've selected "Project" in the "Report on" drop down menu, but there is no "task" option in the related data table.  Am I missing something?

Jon Benusa 0 votes
0
Avatar

Apologies, I put it the wrong way round, you select Task first and then Project (Probably suggest using Parent Project) as the linked data.  Looking at some of my other reports using Work Item as the first option also allows access to both task and project data. 

Phil Smith 0 votes