Report from multiple tables

[zab]

Hello everyone

I need your help once again (it's been a while since my last post).

I'm trying to build a report but I'm having a little problem. There is one data that I just can't bring in it.

I have two tables.

1. Working time table.

2.Project table.

What I need to do.

I need to find a way to calculate how much time it takes to build a 100 linear feet wall. more precisely how much minutes per linear feet it takes to build this wall.

With a Report that include all the projects all work fine

If I want a weekly report that is the sum of all report it doesn't work. I can't find the solution that will calculate the sum of the projects' linear feet of all the project or just a few selected one.

I just made a file to show you everything… of course its simplified and unfinished but you get everything you need in there.

Right click here to download the file here

Look at the Project report it work perfectly

But in the weekly Report, the Lin Feet results should be the sum of all projects.

I have not included my failed tests in it… so don't look for the right field to calculte this as I have not found the way to do it.

I feel the problem is that I must get summaries from 2 different tables in one report.

I'm really lost.

Thank you very much for your help.

Isabelle

[bruceR]

What is a subtask? Why is it not really treated as a subtask? ( child record to task)

[bruceR]

Not complete; but part of the issue here is data structure. Lumping the material in at the project record level does not allow you to report on it easily.

project1.fp7.zip

[zab]

Hello

Sorry it took a while for me to answer. I've been busy and away.

I looked to your file and, just like mine is seems impossible to extract datas from du sub-task.

So I finally built a new table for the report and with a script I gather all the datas that I need and put it in that table. Now the report is just what I wanted. It just took a little more work to create it.

Thank you for your help it's appreciated.