This one is making my head hurt - because the data for customer counts cannot be simply rolled up from the children into the summary rows (2 reps serve same customer), and has to be calculated in the stored procedure, I am getting a total row back in the data for each parent. I want to use the data in this total row but _not_ display the row. I worked out that if I use the MAX function in the parent summary fields e.g.
<mx:SummaryField dataField="tot_cust_cnt" operation="MAX" label="custs_sold_cnt"/> the parent summary row will be correct as the "total row child" will always be the largest value. But I need to not display this "total row child". Is this possible? (I am using the tree/adg because of the large number of rows - collapse makes these manageable). Data example: Mgr/Rep custcount Mgr1 6 = summary field Ttl 6 - this child row used for MAX but do not display Rep1 2 Rep2 2 Rep3 3 As always TIA, Mic.
