Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Create Report with detail records

Posted on 2008-10-08
4
Medium Priority
?
243 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
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Conversion Steps for merging and consolidating separate Filemaker files The following is a step-by-step guide for the process of consolidating two or more FileMaker files (version 7 and later) into a single file with multiple tables. Sometimes th…
Having just upgraded from Filemaker 11 to Filemaker 12 over the weekend, we thought we would add some tips for others making the same move.  In general, our installation went without incident. Please note that this is not a replacement for Chapter 5…
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
How can you see what you are working on when you want to see it while you to save a copy? Add a "Save As" icon to the Quick Access Toolbar, or QAT. That way, when you save a copy of a query, form, report, or other object you are modifying, you…

581 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