Page 1 of 1
Running sum in form
Posted: Wed Apr 19, 2006 10:34 am
by 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
Posted: Thu Apr 20, 2006 1:08 am
by 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>
Posted: Thu Apr 20, 2006 1:51 am
by 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
Posted: Thu Apr 20, 2006 1:59 am
by 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
Posted: Thu Apr 20, 2006 2:51 am
by 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
Posted: Thu Apr 20, 2006 3:41 am
by sikandar
In query you may get the desired results but issue is insert/update/delete.
Posted: Sat May 06, 2006 5:44 am
by mirza_rehan
Assalam-o-Alaikum
I have done it.. with 2 different ways
thanks & regards
When ever you pray
Please remember me and my family
Posted: Mon May 08, 2006 2:56 am
by admin
Incomplete post?
Posted: Mon May 08, 2006 5:57 am
by 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
Posted: Mon May 08, 2006 6:08 am
by admin
Posted: Mon May 08, 2006 12:29 pm
by 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