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
_______________________________________________
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]@union-spring.com
** 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.
