Paul, SQL to put the data into a single cursor then a simple report grouping level Parent.p_desc, simple.
Forget about coding the tables into the DE of the report, its much easier to create a composite single cursor using SQL. Left Join will get you the P_Desc's that don't have any children associated with them. Dave -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Paul Newton Sent: 02 December 2011 09:43 To: [email protected] Subject: Report design problem I have two tables with the following records: parent.p_id parent.p_desc 1 Parent-One-One 1 Parent-One-Two 2 Parent-Two-One 2 Parent-Two-Two child.c_id child.c_desc 1 Child-One-One 1 Child-One-Two 2 Child-Two-One 2 Child-Two-Two I need a report that looks like this: Parent-One-One Parent-One-Two Child-One-One Child-One-Two Parent-Two-One Parent-Two-Two Child-Two-One Child-Two-Two I would really appreciate any suggestions Paul Newton --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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.
