It sounds to me like the target alias isn't right and the parent and relations aren't right. Make sure you have the PARENT table (items) selected when you run report and the parent has relations to the children (POs and Orders). It's also very important that the target alias of the first detail band is the name of the PO cursor (using quotes) and the target alias of the second detail band is the Orders cursor (using quotes).
If you still can't figure it out, post the code used to set this up and a screen shot of the report definition. If I see it, I might be able to spot the problem. Cathy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John J. Mihaljevic Sent: Friday, June 20, 2008 10:17 AM To: [email protected] Subject: RE: Setting up a complex report 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: [EMAIL PROTECTED] [mailto:profoxtech- > [EMAIL PROTECTED] On Behalf Of Cathy Pountney > Sent: Friday, June 20, 2008 8:11 AM > To: [EMAIL PROTECTED] > 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: [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.
