Pull specific values from a related table to a column in a report
I'm sure this has been asked many times before, but I was unable to find the right keywords to get an answer. I'm hoping that someone can point me in the right direction.
I have a Project table that has related join table that matches up employees with the role that they're performing for that Project. Something like this:
Projects ------- TeamRole ------- Employees
There is a Role field in the TeamRole table and the information is displayed and entered from a portal on the project screen. Now i've been asked to produce a report that lists some roles as a column in a list report. So I need to be able ro report on a project and have the employees that are Project Manager, Developer, Interactive Designer and Quality Assurance for that project appear in a column on the report. Like this:
Project Name Description Date Started Project Manager Deveoper Interactive Designer QA
How is the best way to do this? I was able to put a filtered portal in the row and see the team members on the report that way. But it doesn't feel like it is the proper way to do this. I would rather be able to have a calculated field or a relationship on the graph that will let me "grab" the actual value. I'm sure I'll be needing to use the information later on as development continues.
Thanks for any help.