Running sum in form

[mirza_rehan]

Assalam-o-alaikum

I want runing sum in form like this

EMPNO ENAME DEPTNO SAL SUMSAl
----------------------------------------------------
7799 ABC 10 500 500
7798 xyz 10 800 1300
7800 WBX 10 900 2200
7800 TEST 20 1000 1000
7800 T1 20 500 1500
7800 T2 20 900 2400


if it is possible please tell me how??


thanks in advanc


regards,

R E H A N M I R Z A





When ever you pray
Please remember me and my family

[admin]

Pl download the file as a sample. There may be other way but I got the result in this way so...



[img]/images/icon_zip.gif[/img] <b>Attachment:</b> running_sum.zip <i>( 4276bytes )</i>

[mirza_rehan]

Thanks for your reply but i need dept wise breakup and also i works when i enter data

is it possible???

thanks in advance


best regards,
R E H A N M I R Z A

When ever you pray
Please remember me and my family

[admin]

Just paste the code of post_query in when_validate trigger of your sal field. Only issue you will face is when you will change the previous records. But hope now you can develop a logic to resolve even this issue. thanks

[mirza_rehan]

Assalam-o-Alaikum

First of all thanks for previous reply.
Sir i think you dont understand me problem is that i want Running sum Dept. wise i mean i depart will change its count will 0 and start sum againg


thanks
R E H A N M I R Z A

When ever you pray
Please remember me and my family

[sikandar]

In query you may get the desired results but issue is insert/update/delete.

[mirza_rehan]

Assalam-o-Alaikum

I have done it.. with 2 different ways


thanks & regards

Code: Select all

<b>R E H A N   M I R Z A</b>

When ever you pray
Please remember me and my family

[admin]

Incomplete post?

[mirza_rehan]

Here is my sample to get running sum department wise in forums 6i.


[img]/images/icon_zip.gif[/img] <b>Attachment:</b> running_sumdept.zip <i>( 8371bytes )</i>


Best regards,
R E H A N M I R Z A

When ever you pray
Please remember me and my family

[admin]

topic.asp?TOPIC_ID=85

[mirza_rehan]

Dear admin i have mail you sample form please attached it under thus thread

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family