People Report Listing Projects | Community
Skip to main content
C
ChristineFi1
Level 2
March 6, 2024
Question

People Report Listing Projects

  • March 6, 2024
  • 3 replies
  • 747 views

Is it possible to use switch to text mode code to build a report that lists all People (Column A), then in Column B, a list of projects per Person? I've used the code that helped me list People on each Project. But I'm trying to find a way to list Projects on each Person. 

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    3 replies

    skyehansen
    Community Advisor
    skyehansenCommunity Advisor
    Community Advisor
    March 6, 2024

    this isn't possible using the in-app reporting.

    Seanna_Hdz
    Seanna_Hdz
    Level 2
    March 7, 2024

    An option would be to use a project report and group by user. You could still have a column that displays the user's name so that it is visible in line with the project name. 

      C
      ChristineFi1Author
      Level 2
      March 14, 2024

      I used text code from this conversation to get a report of people but it was grouped by project and not by people. Then I had my Analytics Team manipulate the data and load it into Power BI for the view we need. If I can come up with a work-around outside of the system to get to this information, I'm disappointed in WF for making me have to do so instead of creating a simple reporting solution within WF. I cannot understand why this is not standard reporting. 

      Doug_Den_Hoed__AtAppStore
      Community Advisor
      Doug_Den_Hoed__AtAppStoreCommunity Advisor
      Community Advisor
      March 14, 2024

       

      Hi @christinefi1,

       

      I invite you to consider deploying the Package solution I mentioned in this Reporting on Project Count by User post, in case -- since it runs natively within Workfront --  it suits your needs.

       

      Regards,

      Doug

      Terms & ConditionsAccessibility statement

      Loading footer...