create a report layout with two portals per record...
I am trying to create a report layout that is sorted according to child then under each line of child have two portals from another layout displaying the parents of the child (one row in each portal and one portal for each parent). Then under each portal displaying the parents I would like a portal with two rows displaying both the parents of the parent (thus the grandparents of the child).
I have the children, parents and grandparents in three different tables and there are relationships between them.
Do anyone know how to do this?