AngChristman
MIS
Is there a way to use a sub report value in a formula?
What we have is 3 different databases.
1 for estimating
1 for planning
1 for shop floor data collection
I need to get the estimated run time (from estimating) and subtract the actual time (from shop floor data collection). In order to do this, I have to cross two different databases. This causes the report to take way to long to run and it almost causes a system shut down.
If i make a sub report for the actual time (just that field) I can put it into the report and it doesn't take long to run at all. The problem is I don't see how I can write a formula where I take the estimated value from the report and subtract the data in the sub report.
What we have is 3 different databases.
1 for estimating
1 for planning
1 for shop floor data collection
I need to get the estimated run time (from estimating) and subtract the actual time (from shop floor data collection). In order to do this, I have to cross two different databases. This causes the report to take way to long to run and it almost causes a system shut down.
If i make a sub report for the actual time (just that field) I can put it into the report and it doesn't take long to run at all. The problem is I don't see how I can write a formula where I take the estimated value from the report and subtract the data in the sub report.