Home » Developer & Programmer » Forms » sum emp.sal before commit in tabular style (10g,developer 6i,window XP)
icon1.gif  sum emp.sal before commit in tabular style [message #379958] Thu, 08 January 2009 11:33 Go to next message
shahzaib_4vip@hotmail.com
Messages: 376
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
Re: sum emp.sal before commit in tabular style [message #379971 is a reply to message #379958] Thu, 08 January 2009 14:21 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Create a summary item. How? Read in Forms Online Help System.
icon1.gif  Re: sum emp.sal before commit in tabular style [message #380277 is a reply to message #379958] Sat, 10 January 2009 01:17 Go to previous messageGo to next message
shahzaib_4vip@hotmail.com
Messages: 376
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
Re: sum emp.sal before commit in tabular style [message #380290 is a reply to message #380277] Sat, 10 January 2009 03:47 Go to previous messageGo to next message
Littlefoot
Messages: 20901
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.

./fa/5560/0/
Re: sum emp.sal before commit in tabular style [message #380319 is a reply to message #379958] Sat, 10 January 2009 11:39 Go to previous message
shahzaib_4vip@hotmail.com
Messages: 376
Registered: December 2008
Location: karachi
Senior Member
Thanks you very much sir


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


Current Time: Fri Dec 09 03:43:15 CST 2016

Total time taken to generate the page: 0.09665 seconds