sumary in footer band using subreports ...?

rbuser

Hello,

I have master dataset and one-to-many detail dataset
master has a header band and detail band.
Master is groupped on some one-field key
There is a subreport on master's detail band.
Subreport has only detail band - dynamic heigh with dbmemo

I have to sumarize in footer band the master field 'price'
How should I do it?

Now, I have a ppVariable on footer band:
calculate on: traversal / datapipeline traversal
reset on: page start

It doesn't work. It adds record value of next page, so then sum is
overcharged.

I tried to use detail band Before Generate event, but I couldn't manage to.
Especially, when master's header band is printed and detail band
does on next page - then sum is overcharged to.

Where is my fault?
Any suggestions?

Thank You for help,

with regards,
Agnieszka Jakubiec

rbuser

i had your problem too !!
i "resolved" putting the totals in the Sumary of subreport ....
the result isn't the best .... but to the customer had haste .... :P


"Agnieszka Jakubiec" ha scritto nel messaggio

rbuser

I'm afraid, Your case differs my

I want to have totals in _footer_ band of the _page_
Another words the issue is: to sumarize master field 'price' on every page
separately

Thank You for answer,
best regards,

Agnieszka akubiec


U?ytkownik "Diego" napisa? w wiadomo?ci

rbuser

i apologize ... it's for my bad english !! :-)
maybe you can do a sum in the OnPrint event of your component ...
but i think it can be very dangerous ... (2 or 1 pass setting etc etc )

bye !

"Agnieszka Jakubiec" ha scritto nel messaggio

nicocizik

Hi Agnieszka,

This was a tricky problem. I was able to solve it by forcing the first
value of the next page to reset itself to it's original value from the
dataset in the DetailBand.BeforeGenerate event. This essentially ignores
the TppVariable cache used in the OnCalc event and gives the correct
individual page totals. Hope this helps.

http://www.digital-metaphors.com/tips/PageSubTotal.zip

--