I'm building an Ancestry database. I have a query that pulls data from 4 different tables, person, sibling, spouse, children. The query returns info about the person, then a few details from each of the other three tables. I'm trying to build a report, using the Oracle reports extension (ORB) and I'm on version 4.15 of AOO, running on Windows 10. I have two problems.
First, I want to build a master detail report that lists the person info and then displays the rows for the spouses, then siblings, then children. If I put all this info in the detail section, then the report outputs, spouse row, sibling row, child row and then it repeats. I want to group all the spouse data together, then the sibling rows and finally the children. These are not nested sub-groups, they are independent of each other, beside the fact that they all relate to the same person. I tried putting the data from each of the sub-groups, for lack of a better word, in different regions of the report. I made a version where I broke on person_id and included both the header and footer sections on either side of the detail section. It almost worked, but it didn't, the footer section with detail info only iterated the one time with the person_id and missed additional child records.
It's like I need multiple detail sections, or is there a way to handle it by formatting the individual cells within the detail section?
My second problem is that ever since I added the ORB to my AOO. I keep crashing and corrupting my database file. One second, I'm working away and the next, then entire application has closed and is gone from view. When you try to relaunch the database file, AOO doesn't know how to open it. Anybody else having this problem?
Thanks in Advance,
Barry