How to remove duplicate project names in an Assignment Report?

[mvsteep]

Hi everyone! i am working on an Assignment report for a project team so they can see all the completed projects they were assigned to. This report is based on the $$User so it'll be a custom view for whomever opens the report. If a user was assigned to multiple tasks in a project it will show up multiple times on this report, and they don't want to see the task name they just care about seeing which project name they worked on. Is there a way to remove these duplicate items on the report or should I utilize a different report for this request? As always, thank you all!

[KellieGWAB]

You can group an assignment report by the project name and then have the default page be the "summary" page. Then it should jus show a count of how many assignments they had in said project. 

Only caveat is that the project name won't be clickable from the summary page if that's a need. 

[mvsteep]

Thanks for your response! Summary section, minus the count column, is the look my stakeholders want but it doesn't look that way when the report is emailed to them on a monthly basis since it reverts to the detailed section view.

[skyehansen · Accepted solution]

You can create a project report, and filter for the project status you want (completed project statuses). Then switch over to text mode and copy / paste in Jon Chen's code from the "Record Count of Projects" section.

https://experienceleaguecommunities.adobe.com/t5/workfront-blogs/common-reporting-challenges/ba-p/51...

[mvsteep]

@skyehansen this was perfect, thank you so much!!!