Home » Developer & Programmer » Forms » Totaling in form
Totaling in form [message #79381] Tue, 04 June 2002 22:33 Go to next message
annu
Messages: 34
Registered: February 2002
Member
i have a master detail form .. where in detail tabular form i make some non-db (suppose ABC) item with setting the property calcutaion - Formula ABC = col_a+col_b and make some calculation there .. it works and give me a perfect result.. well now I want to make a summary item on this calculation .. i mean i want an item display down the ABC and give me the summary total of ABC item. I did alot but nothing work.. what to do help me in this regard.

1- if an item is nondb and it is also a calculated item .. is it possiable to summarize it in another nondb item?. While pre-comput summaries and query all record is set to YES. and both the items are in same block.
Re: Totaling in form [message #79391 is a reply to message #79381] Wed, 05 June 2002 23:25 Go to previous message
alka
Messages: 10
Registered: January 2002
Junior Member
Hi Annu,

i think you can do this. try this code in master block (say after you complete the entry in tran. block and return back to the master)

go_block('trans');
first_record;
loop
summary_field:= summary_field+:cal_field_of_trn_blk;
if :system.last_record='true' then
exit;
else
next_record;
end if;

end loop;

i have used this technique in many forms and it works fine for me.

best wishes

alka
Previous Topic: To directly run the oracle report for forms without any interface
Next Topic: how to avoid an empty items in poplist item
Goto Forum:
  


Current Time: Thu May 23 03:43:49 CDT 2024