Create Report with detail records

I have 3 tables: projects, tasks, workers
And i like to create a report that shows on one page per project the related tasks and the worker which have to do the task.
I'm not able to get the relation between this tables on my report.
For me it looks like that the report can only handle one table.
But this can not be.
Who is Participating?
Are you using a script to print your report?  As you print each page, GoTo the layout where the correct relationship exists.
assuming these 3 tables are linked properly, the best is to do the layout in the tasks table, with sub_summaries to break on worker, then project.
so 1st sub-summary is on worker, 2nd on projects
body is the task.
sort records worker/project/task

to switch page for each worker, simply check the sub-summary properties to goto a new page on each occurence
ibelingAuthor Commented:
Dear lesouef,

thanks for your quick response.  Can you please explain a little bit more in details how i can implement your idea?

My tables:

tbl_customer: key=custID
tbl_project: key=projectID; relation(projectID;custID)
tbl_task: key=taskID; relation(taskID, projectID)

and i like to have on my report:
May be you have a sample which is doing is something like this?

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.