AnsweredAssumed Answered

How to make a report with three related tables

Question asked by cob on Feb 5, 2019
Latest reply on Feb 5, 2019 by beverly

I do have a Parent, Child and Grandchild tables with a relation one to many and I want to make a report as follows:





If I base the report on the Child table the Parent and Child appear correctly as liked, but on the sub summary of the grandchild appear always the same value.


If I base the report on the Grandchild table only the first Parent and Child combination appear but the others don´t and the the Grandchildren doesn't appear at all.


If I base the report on the Parent table all the parents data appear combined only with the first child of each. Grandchildren data doesn't appear.


Can someone indicate what did I made wrong?