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: profox-bounces@leafe.com [mailto:profox-bounces@leafe.com] On Behalf

Of John J. Mihaljevic

Sent: Thursday, June 19, 2008 1:18 PM

To: profox@leafe.com

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]