How to reset running total after group change?

[stvhui]

Hello to you,

group_code item_code amount running amount
A 3 30 30
A 2 20 50
A 1 10 60
Sub total 60

B 2 200 260 ---> should be 200
B 1 100 360 ---> should be 300
Sub total 300

I included above case in attachment, data (in ms-access), report (in mrt) and report output (in pdf)

Please help and thanks in advance.

Regards,
Steven

[Alex K.]

Hello,

Please try to use the following code in BeforePrint event of GroupHeaderBand1 component:
Text5_Sum.Reset();

Thank you.

[stvhui]

Hello to you Aleksey,

It's long time not involved in using stimulsoft report.

Would mind to guide me, how to put the code as you shown.

Please guide step by step using my attached example.

Thanks in advance

Steven

[Jan]

Hello Steven,

Please check attached image.

Please contact us if you need any help.

Thank you.

[stvhui]

Hi Aleksey,

at the end, I solved it by your answer.

Thanks a lots

Regards,
Steven

[Andrew]

Hello,

Great! Have a nice day.