If you're using VFP 9, use multiple detail bands to solve this.
Here are the tables you need:
Items: Type, Size, Pounds
Index: Type + Size
Po: Type, Size, Number, Pounds, Vendor
Index: Type + Size + Number
Order: Type, Size, Number, Pieces, Customer
Index: Type + Size + Number
SELECT Items
SET RELATION TO Type+Size INTO PO
SET RELATION TO Type+Size INTO Order ADDITIVE
Create the report:
Data Group #1: Type
Put the "TYPE" line here
Data Group #2: Size
Put the "SIZE" info here with the quantity in stock
Detail Band #1: Target Alias = "PO"
Put the PO Info here
Detail Band #2: Target Alias = "Order"
Put the Order info here
That should give you what you want.
Cathy Pountney
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf
Of John J. Mihaljevic
Sent: Thursday, June 19, 2008 1:18 PM
To: [email protected]
Subject: Setting up a complex report
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
[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.
