Retrying this with rich text option to try and retain formatting:
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
--- In [email protected], "MicC" <chigwel...@...> wrote:
>
> 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.
>
