| Totaling in form [message #79381] |
Tue, 04 June 2002 22:33  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
