OraFAQ Forum: Forms » sum emp.sal before commit in tabular style

Home » Developer & Programmer » Forms » sum emp.sal before commit in tabular style (10g,developer 6i,window XP)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sum emp.sal before commit in tabular style [message #379958]

Thu, 08 January 2009 11:33

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Well my question is

i create data block with tabular style of emp (10 record display) and also create one text box now i need when i enter data of emp sum the salary of employee in text box before commit

Any idea

Thanks

Shahzaib

Report message to a moderator

Re: sum emp.sal before commit in tabular style [message #379971 is a reply to message #379958]

Thu, 08 January 2009 14:21

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Create a summary item. How? Read in Forms Online Help System.

Report message to a moderator

Re: sum emp.sal before commit in tabular style [message #380277 is a reply to message #379958]

Sat, 10 January 2009 01:17

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

i already create a summary item

actually i think you don't understand my question
or i am not be able to explain clearly

i create a mobule base on emp data in tabular style and the row is 10 and one other block and create a text item which name is "S"

now i need when i enter data in emp form sal total will come at "S" text item

for example

empno---employee name--Deptno--Sal--comm
7788----Smith-----------10----2500--0
7780----johns-----------20----1000--0
7791----king------------10----1200--

now S text item show 4700

i hope now i explain clearly

any way

Thanks for your reply

Shahzaib Ismail

Report message to a moderator

Re: sum emp.sal before commit in tabular style [message #380290 is a reply to message #380277]

Sat, 10 January 2009 03:47

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I'm afraid that you haven't create the summary item properly.

It can be placed into the same data block as the rest of items; set its "Number of Items Displayed" property to 1. Data block's "Query All Records" property should be set to Yes. Calculation properties and the result can be visible on the screenshot.

/forum/fa/5560/0/

Attachment: summary_item_2.PNG
(Size: 8.46KB, Downloaded 1076 times)

Report message to a moderator

Re: sum emp.sal before commit in tabular style [message #380319 is a reply to message #379958]

Sat, 10 January 2009 11:39

shahzaib_4vip@hotmail.com
Messages: 410
Registered: December 2008
Location: karachi

Senior Member

Thanks you very much sir

Report message to a moderator

Previous Topic:	Hide Blanks in a List Item - Tricky Situation!
Next Topic:	how to make Demo Software

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue May 05 21:15:50 CDT 2026