Skip to main content
Question

Help on a report filtering data based on a "Team"

  • November 22, 2019
  • 0 replies
  • 80 views

Forum|alt.badge.img+11
I have an app with a structure where I have Tasks related to Team Members (A Team member can have many tasks).
In this same App Team Members is related to Departments (A Department can have many team members).

In a report for tasks I need to generate a task listing for all tasks associated with one team.  I can do this manually for each team, but I was hoping to do it dynamically based on who is logged on.

So for example, lets say I am part of the Strategic Accounts Team.

I want my report to filter all of the tasks to show all open tasks assigned to anyone on the Strategic Accounts Team.

I know how to dynamically filter by user.  But how do I do it by "Team Name" which is a field in the departments table?

Thanks!

------------------------------
Ivan Weiss
------------------------------

AdamKeever1
Forum|alt.badge.img+2
You need to add that field as a lookup in your relationship. Then you can use it in the dynamic filters. Here is an example where[ID - Workstreams] is a lookup field that is used as a dynamic filter:





------------------------------
Adam Keever
------------------------------