I'm having to address this same question. Did you ever find a solution to
this? Anyone else know how to do this or if it is (not) possible? The issue
is that using a recursive hierarchy the group header/footer occur at the row
level and the next level down has it's own header/footer. Thus, I can't
figure out a way to add the lower "Total" display. Thanks for any help.
rSmoke
[quoted text, click to view] "Pankaj" wrote:
>
>
> "Pankaj" ने लिखा:
>
> > I'm using recursion, the values use the 'recursive' option in the SUM
> > function, i.e. =Sum(Fields!Value.Value,"table1_Detail_Group", recursive)
> > It produces;
> >
> >
> > Total Assets -1332
> > Net 475
> > Fixed Assets 1641
> > Depreciation -1166
> > Investments 179
> > Liabilities -1986
> > Creditors -1567
> > PAYE -141
> > Corporation Tax -278
> >
> >
> > What I want to produce is;
> >
> > Fixed Assets 1641
> > Depreciation -1166
> > Net 475
> > Investments 179
> > Creditors -1567
> > PAYE -141
> > Corporation Tax -278
> > Liabilities -1986
> > Total Assets -1332
> >
> >
> > Is it possible to control sub-totalling in this way with recursion .
>
>
> Let me give another example which will help to undersatand my problem
> Curremtly I am getting data in following format
>
> Employee Sales
> Robert 850
> David 450
> Mary 100
> John 200
> Alex 150
>
> Jim 400
> Andrew 250
> Tony 150
>
> What I want to produce is;
> Employee Sales
> Robert
> David
> Mary 100
> John 200
> Alex 150
> Total David 450
> Jim
> Andrew 250
> Tony 150
> Total Jim 400
> Total Robert 850
>
> Is it possible to control sub-totalling in this way with recursion .
>
> Thanks
>
>
