Home » Developer & Programmer » Forms » running sum based on feild value (oracle forms,6i,xp)
running sum based on feild value [message #343247] Tue, 26 August 2008 14:38 Go to next message
yoonus.it@gmail.com
Messages: 109
Registered: June 2007
Location: kuwait
Senior Member


Hi Friends,

I have new scenario. I have a master detail relation as follows

Head   ID
100     1

Emp    ID   total 
101     1     11     
101     1     10
102     1     10
101     1     10
102     1     10

on display form i have the following format

Emp    ID   total   utilised approved
101     1     11       3      3
101     1     10       
102     1     10       

now when i enter a new value in the approved text feild i want to sum all the columns with same emp no.
ex:
if i enter again 2 in approved column of the second row the result im expecting is

Emp    ID   total   utilised approved
101     1     11       5     3
101     1     10       5     2
102     1     10


Looking forward to your expert advice

Thanks in advance :)



Re: running sum based on feild value [message #343255 is a reply to message #343247] Tue, 26 August 2008 15:18 Go to previous message
szogu
Messages: 21
Registered: July 2008
Junior Member
Check out Calculation Mode Property In online help of the oracle forms. You need to set that property to summary and then set the other properties (summary function,summerized block,summerized item). Online help explains what to do.

Regards,

Previous Topic: Oracle Forms Books
Next Topic: calculation
Goto Forum:
  


Current Time: Thu Dec 08 10:21:54 CST 2016

Total time taken to generate the page: 0.05817 seconds