0

Heirarchical queries in Jet Essentials

Jet Reports Historic Posts

March 03, 2015 18:26

None

Follow

Is it possible to have hierarchical queries within Jet reports.
For example I need all children with their parents and the path from child to parent could go through different generations ?
Child A –> Parent A1 –> Grandparent A2
Child B –> Parent B1
Child C –> Parent C1 –> Grandparent C2 –> Great Grandparent C3

The output of the report should be
A –> A2
B –> B1
C –> C3

• Facebook
• Twitter
• LinkedIn

3 comments

• -1
  
  Jet Reports Historic Posts March 04, 2015 14:19

  I could easily do it in VB if you used jet to get out the raw data. Can you give us any idea about what you're actually trying to achieve?

• 0
  
  Jet Reports Historic Posts March 05, 2015 15:42

  In Jet, there isn't a way to do this because it requires a recursive call to itself until it finds the "end of the line".

• 0
  
  Jet Reports Historic Posts March 07, 2015 15:02

  In Jet, there isn't a way to do this because it requires a recursive call to itself until it finds the "end of the line".

  
  Unless you assume that the 'end of the line' isn't further away then say 10 stops.
  Then you can calculate each level and take the last not empty level as a result.
  
  But I agree with JET-btr: no recursion possible in Jet.
  
  rmw