Hi all,

I'm having trouble creating a pretty involved report. It is to list our

different raw material types and sizes. Under each type and size, it's to

list any outstanding purchase orders we have for more of that size. And

under that, it's to list any customer orders we have open for products that

are made with that size. For example:

TYPE A

------

SIZE 1 1,000 pounds in stock

Purchase Order 1: 10,000 pounds from Vendor #1000

Purchase Order 2: 15,000 pounds from Vendor #2520

Order 100: 50 pieces for Customer #950

Order 102: 75 pieces for Customer #188

SIZE 2 1,985 pounds in stock

SIZE 3 44,500 pounds in stock

Order 204: 125 pieces for Customer #1010

TYPE B

------

SIZE 1 0 pounds in stock

Purchase Order 5: 5,500 pounds from Vendor #988

As you can see, some sizes have outstanding PO's and outstanding Orders

(Type A, Size 1), some have one or the other (Type A, Size 3 and Type B,

Size 1) and some have neither (Type A, Size 2).

I've tried creating the report with different grouping, additional detail

line bands, etc., and it's just not happening. I have the Type as Group

Heading 1, and then have tried a couple different ways to handle the rest

with different Grouping or multiple detail lines. But no matter which why I

go, it doesn't pull the correct PO's and Orders for the detail information.

Can anyone suggest a method to attack this?

Thanks very much,

John