Author: John J. Mihaljevic
Posted: 2008-06-20 at 10:17:14
Thanks very much, Cathy. It's got me closer, but I'm still not there. I'm
getting (from my original example):
TYPE A
------
SIZE 1 1,000 pounds in stock (I'm only getting this detail once for each
Type)
(The headline for the Purchase Order info, but no detail)
(The headline for the Order info, and a list of every Order in the
system...not just those for the correct material Size)
Also, although I'm only getting the detail for the first Size within each
Type, it still gives me a "break" for each new Size...just doesn't show the
detail. But it's clearly breaking, because it gives me another headline for
the Purchase Order info, and lists every Order in the system again.
>From all I can see, I set things up exactly as you outlined in your email.
Is it possible that I've got the "Target Alias" entered incorrectly? Should
I filter the Purchase Order and Order tables somehow? Should all this be
set up in the form that calls the report or done through the Data
Environment section of the Report?
Thanks again!
John
> -----Original Message-----
> From: profoxtech-bounces@leafe.com [mailto:profoxtech-
> bounces@leafe.com] On Behalf Of Cathy Pountney
> Sent: Friday, June 20, 2008 8:11 AM
> To: profoxtech@leafe.com
> Subject: RE: Setting up a complex report
>
> 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]