Is there a way to add Home Team to a User Report?

Forum|Forum|5 years ago
August 7, 2020
2 replies
922 views

I'm trying to pull a User report with Project and Task assignments and want to group by home team. The only field I seem to be able to add for team data includes all teams the user is assigned to.

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

KatherineLa

Community Advisor

Hi Joanna,

I'm not quite tracking which base object you're starting the report from, but generally there should be options for 'Home Group' or 'Home Team' versus a generic Group/Team field in most report objects. That will pull you the ID, and then you can use text mode to switch it over to the :name field to display the regular text.

If you can clarify which object you're starting the report with, I can get more specific with details.

Katherine

J

JoannaPa1Author

Level 2

Hi Katherine,

I'm looking at a User report because I need to be able to report on the individual assignments on all project tasks. Can you please provide an example of how to get the Home Team ID to display name? I've tried a couple of things in text mode and it just leaves me with no data in that field on the report.

KatherineLa

Community Advisor

Sure thing. Here's a quick write-up for you.

That being said, I'm not sure you're going to have much luck getting that information if you start from the User report base. That's more used for reporting on the user themselves (login access, schedules, managers etc), not the work they're assigned. You might find it less frustrating to start from a Task report base.

You'll still need this trick if you start from there, but you'll get a lot richer data available natively without having to switch to text mode as much.

Kundanism

Level 10

👍

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded