Hi Cathy,
Here is a screen shot of the report definition: > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:profoxtech- > [EMAIL PROTECTED] On Behalf Of Cathy Pountney > > It sounds to me like the target alias isn't right and the parent and > relations aren't right. Make sure you have the PARENT table (items) > selected when you run report and the parent has relations to the > children (POs and Orders). It's also very important that the target > alias of the first detail band is the name of the PO cursor (using > quotes) and the target alias of the second detail band is the Orders > cursor (using quotes). > > If you still can't figure it out, post the code used to set this up and > a screen shot of the report definition. If I see it, I might be able to > spot the problem. Here are my tables and relations (all of which are in the Data Environment section of the report definition) Tables: RAWMATERIAL order GRADE_DIAM str(grade,2)+str(diameter,6,4) RAWCODES order RAWCODE (This give me DESCRIPTION in the Group Header 1 band) PODETAIL order GD_NUMBER str(grade,2)+str(diameter,6,4)+str(po_number,5) POHEADER orde PO_NUMBER po_number ORDERS order GD_NUMBER str(grade,2)+str(diameter,6,4)+str(ordernumber,5) Relations: RAWMATERIAL to ORDERS gr_diameter RAWMATERIAL to PODETAIL gr_diameter RAWMATERIAL to RAWCODES grade PODETAIL to POHEADER po_number Here is an example of the output I'm getting: As you can see, I'm getting no PO Detail but EVERY Order in the system for every grade_diameter. Each time grade_diameter changes, I get a new list of nothing for Purchase Orders, and another list of every Order in the system.. If there's anything else you need to see in order to help me figure this out, let me know and I'll reply right away. Thanks very much for your time and your help! John --- StripMime Report -- processed MIME parts --- multipart/related multipart/alternative text/plain (text body -- kept) text/html image/png image/png --- _______________________________________________ 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.
