Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Create Report with detail records

Posted on 2008-10-08
4
Medium Priority
?
238 Views
Last Modified: 2012-05-05
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.
0
Comment
Question by:ibeling
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 3

Expert Comment

by:D0N
ID: 22668586
Are you using a script to print your report?  As you print each page, GoTo the layout where the correct relationship exists.
0
 
LVL 28

Expert Comment

by:lesouef
ID: 22668732
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
preview.
done.

to switch page for each worker, simply check the sub-summary properties to goto a new page on each occurence
0
 

Author Comment

by:ibeling
ID: 22687122
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:
----------------------------
tbl_customer.customerName;.....
    tbl_project.projektName,...
        tbl_tasks.taskName
-----------------------------------
May be you have a sample which is doing is something like this?

Regards
0
 
LVL 28

Accepted Solution

by:
lesouef earned 2000 total points
ID: 22687870
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Pop up windows can be a useful feature of any Filemaker database.  Though best used sparingly, they can be employed in a multitude of different ways, for example;  as a splash screen at login, during scripted processes to control user input, as pick…
Problem: You have a hosted FileMaker database and users are tired of having to use Open Remote or Open Recent to access the database. They say, "can't you just give us something to double-click on rather than have to go through those dialogs?" An…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

670 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question