Hi Cathy,

Here is a screen shot of the report definition:

> -----Original Message-----

> From: profoxtech-bounces@leafe.com [mailto:profoxtech-

> bounces@leafe.com] 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

---