I need to create a report that shows the following information:
- created by user
- created by user's team
- assigned to user
-assigned to user's team

My problem is that if either the created by or assigned to user belongs to multiple teams, the report returns multiple instances.

Is there a way limit the report to only show the default team for each user, thus eliminating the duplicate returned results?

Sugar Pro 5.0.0i
Windows 2003 Server
MSSQL