0

Parent and child costs

Jet Reports Historic Posts

May 06, 2014 15:56

None

Follow

On our job table we have parent job field (not sure if this is standard nav or not) which is a self join back to the job table. In our report we want to be able to enter the number of a parent job and then return a sum of all job ledger entries for either the parent job or any child jobs. Any help on how I can do this filter would be appreciated.

• Facebook
• Twitter
• LinkedIn

1 comment

• 0
  
  Jet Reports Historic Posts May 07, 2014 07:36

  You can use NL(Filter) to retrieve a list of child jobs for the specified parent job and use that in a NL(Sum) for the job legder entry table.
  
  HTH
  
  rmw