I'm trying to write a report to show the available capacity of a component over the next 26 weeks.
There are 26 columns and in each one I determine the PO demand (Po) in the detail of the report then sum in the footer. There is no grouping in the report and only 2 linked tables. The following are then also calculated in the footer:
- I determine the available weekly capacity (WklyCap)from a parameter.
- The requirement each week (Req)is then Sum ({@Po25})+{@Bal26}. ie the sum of the PO demand plus any residual balances from the previous weeks.
- The amount actually made that week is the capacity available or the amount required (Cap):
if 0">{@Req25}>0 then
(if {@WklyCap">{@Req25}>{@WklyCap} then
{@WklyCap} else
{@Req25})
else 0
- The balance remaining (Bal) is then the required qty minus capacity used
{@Req25}-{@Cap25}
I started with week 26 then worked backwards to current week. I tested after 6 weeks and it was working perfectly so I continued with the formulas for all remaining weeks. When I went to run I ended task after 1 hr!
I appear to have something fundamentally wrong in my report design. Any help much appreciated!
IP Logged
