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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of John J.
Mihaljevic
Sent: Thursday, June 19, 2008 12: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
_______________________________________________
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/005701c8d230$68c5b630$3a51
[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.
Report [OT] Abuse:
http://leafe.com/reportAbuse/[EMAIL PROTECTED]
[EMAIL PROTECTED]
_______________________________________________
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.
