Home » Developer & Programmer » Forms » Cumulative total
Cumulative total [message #116826] Fri, 22 April 2005 07:57 Go to next message
jhsharma
Messages: 58
Registered: June 2004
Member
hi gurus

I have a tabular block with a1,a2,a3.. columns.
I want to display the running sum on col a2. ? I am using oracle 8.0
pl help

Report message to a moderator

Re: Cumulative total [message #117223 is a reply to message #116826] Mon, 25 April 2005 19:06 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
How about a field at the bottom of your canvas 'ctrl.a2_sum'.

In the pre-query of 'blk1' place:
":ctrl.a2_sum := 0;"

Then in 'blk1' post-query place:
":ctrl.a2_sum := :ctrl.a2_sum + :blk1.a2;"

Tell us how successful this works.

David

Report message to a moderator

Previous Topic: using array.
Next Topic: D2K6 and Oracle 9i(9.0.1.1) install in same win xp pc
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 18 20:23:22 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.