Values Repitition

[Mahoney]

Hello everyone,

I have many tables, these tables are details for each task of a project, (example, translation, directing, typing, etc...). The project has an ID number. Most of the tasks are performed by a signle person, but some have more persons.
I am trying to create report to show all the personnel that participated in each task. What is happening is that if a task has 5 directors and 1 translator, i will get 5 reports for the same project, the same people are repeated but only change the director eac time. If i have 10 directors am getting 10 reports for the same project.

How can i get 1 report for each project which shows all the participants under its heading, that is to show all translators under translator, all directors under director, but not to repeat the same translator as many as there are different directors.

I tried dooing it by adding subreports on a single report but it gets very slow

thanks in advance

 

[Mahoney]

I think i found a solution for it, just set the prperty to hide duplicates
its not the best solution but will do i guess. If there is a better way for it to be done will appreciate it
regards

 

[Mahoney]

Hi everyone,
may you please help me on my above issue
i have many tables that are the tasks of a project, each task has its details, and one of these detail is the people that participated in each task. In some cases only one person performed a task and in other cases more that 5 performed a task.
I need a report to show me all the people that participated in each task, but the thing that is happening, is that when lets say one person translated and 5 people directed, i will have the name of the person translated repeated 5 times, as per the number the people directed. I was able to overcome this issue by setting the property to not show duplicates. But a new problem turned out, is that when lets say the project did not need translation, it will show me an empty field as per the number of unique values in any other criteria

in a nutshell, what i need is a simple report where it will shows me under each criteria the people that participated in each task (table), regardless of the number of the poeple.

Your help is highly appreciated
thanks