OWLearner,
I'm supplying a method rather than sample code. I hope that you can follow what I've set out below and that it will help. Please let me know how it goes.
*Parent Asset BV Section - Non conditional, non printing section (hidden or suppress section write) (Use a BV that contains F1201 data including the Parent Asset Number)
Initialize Section ER: Set user selection to select where Parent Number = Item Number
Do Section ER: Loop through Parent Asset BV accumulating any required totals. Save Parent Asset Number to be used to get Child Assets. On change of Parent Asset number, set Child Asset Counter to 0, call Child Assets BV Section, call Printing Section.
*Child Assets BV Section - Conditional, non printing section (hidden or suppress section write) (The BV used for this section could be the same as for the Parent Asset BV Section)
Initialize Section ER: Set user selection to select where Parent Number = Parent Asset Number saved in Parent Asset BV Section and Item Number <> Parent Asset Number saved in Parent Asset BV Section
Do Section ER: Loop through Child Assets BV section accumulating any required totals and counting the number of child assets.
*Printing Section - Conditional, printing section - no BV
Do Section ER: Print 1 line: Parent Asset, Number of Children, any Totals, etc.
When the printing section is complete the Parent Asset BV Section will continue with the next Parent Asset. You'll need to add any required report headers or page headers etc.
Note: The printing could be done in the Parent Asset BV Section if required. This would remove the need for the Printing Section.
