Foxtrotter
IS-IT--Management
Hi, I have a report in VFP9 that involves a parent child to child relationship. Basically, it's customer/order/order detail. Because of other posts I saw in this forum, I created a cursor combining my order header and order detail information into a single cursor so that I now only have one detail band in my report. Therefore, I have one relationship set between my customer table and the new orders/details cursor with a set skip to the order/detail cursor. In my report, I have my detail band which is my actual order detail info (item#, description, qty). I have 3 data groups on a period field, and customer# both contained in the customer table and order# in the orders/details cursor. The output looks like this:
(Sorry, I could not get the indentions to show up in here, at least in preview. Each group (customer, order, details) should be indented over.)
Period: January 2007
Order# Date Total
56790 1/10/2007 $100.00
Item# Description Qty
300 Product A 1
400 Product B 1
500 Product C 1
Order# Date Total
56789 1/10/2007 $100.00
Item# Description Qty
300 Product A 1
400 Product B 1
Item# Description Qty
500 Product C 1
600 Product D 1
Order# Date Total 56789 1/10/2007 $100.00
Everything works well except when the second case happens where I have multiple orders for the same customer in the same period. For some reason, it is reprinting the order header information for the first order again although it does not reprint the detail product information. The order header information is in the group header section for order# and is set to not repeat and to remove blank lines because this same information is contained in each row of the order detail cursor. The group on order# should trigger the new order to print which it does but something is triggering it to start over again when it moves to the next customer. It's like when the group on customer# is triggered, it triggers the group on order# first causing it to fire.
Any ideas on how to prevent this?
(Sorry, I could not get the indentions to show up in here, at least in preview. Each group (customer, order, details) should be indented over.)
Period: January 2007
Customer# Name City/State
123457 Bill Jones Dallas, Tx
Customer# Name City/State
123456 Tom Jones Portland, OR
Order# Date Total
56803 1/29/2007 $120.00
Customer# Name City/State
123458 Will Jones Dallas, TxEverything works well except when the second case happens where I have multiple orders for the same customer in the same period. For some reason, it is reprinting the order header information for the first order again although it does not reprint the detail product information. The order header information is in the group header section for order# and is set to not repeat and to remove blank lines because this same information is contained in each row of the order detail cursor. The group on order# should trigger the new order to print which it does but something is triggering it to start over again when it moves to the next customer. It's like when the group on customer# is triggered, it triggers the group on order# first causing it to fire.
Any ideas on how to prevent this?