You could create your own cursor Create cursor myrep (parent C20),child C(20))
then go through your files in the correct order and insert them into the cursor. When you reach then end of a parent group, insert the children into the cursor, then move to next group. Then the report layout is very simple. HTH * Peter Cushing * IT development and support Signature Paul Newton wrote: > Yes, exactly ... > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Dave Crozier > Sent: 02 December 2011 12:05 > To: [email protected] > Subject: RE: Report design problem > > So you only want to attach the children to the last Parent of a group? > > Is that what your problem is? > > Dave > > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On Behalf Of > Paul Newton > Sent: 02 December 2011 11:57 > To: [email protected] > Subject: RE: Report design problem > > OK Let me re-post with what the data might really look like: > > I have two tables with the following records: > > parent.p_id parent.p_desc > 1 Fred > 1 Mary > 2 Jonathan > 2 David > > child.c_id child.c_county > 1 Essex > 1 Surry > 2 Devon > 2 Cornwall > > I need a report that looks like this: > > Parent Heading > Fred > Mary > Child Heading > Essex > Surry > Parent Heading > Jonathan > David > Child Heading > Devon > Cornwall > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
