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?