John,

First of all, If you're doing a lot of reports

(I assume you're using 9.0)

I'd suggest you get Cathy Pountney's book ...

"The VFP Report Writer: Pushing it to the Limit and Beyond"

from Whil's site. It's worth every penny.

It'll make it a lot easier if you break the data out into

three tables and set the relations accordingly.

Type, Size

PO's

Order's

Then, it you'll need two Groups Bands (Type, Size) and

two Detail Bands (PO's, Order's)

Stick the Type and Size data in the appropriate group header.

Create a second Detail Band.

Set the 'Target Alias Expression' to the appropriate table

for the PO's and Order's.

I think that should handle it with a little fine tuning.

Best,

Francis I. Coppage, Jr.

"Two things are infinite: the universe and human stupidity; and

I'm not sure about the universe."

... Albert Einstein

-----Original Message-----

From: profoxtech-bounces@leafe.com

[mailto:profoxtech-bounces@leafe.com]On Behalf Of John J.

Mihaljevic

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

To: profoxtech@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

_______________________________________________

Post Messages to: ProFox@leafe.com

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/005701c8d230$68c5b630$3a51

2290$@mihaljevic@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.

Report [OT] Abuse:

http://leafe.com/reportAbuse/005701c8d230$68c5b630$3a512290$@miha

ljevic@union-spring.com