Total field from another Block [message #587354] |
Fri, 14 June 2013 06:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.gravatar.com/avatar/a59247482a11edb9544247f102223e8d?s=64&d=mm&r=g) |
mist598
Messages: 1195 Registered: February 2013 Location: Hyderabad
|
Senior Member |
|
|
Hi,
I have 2 blocks named emp,emp1 those are DB's Blocks and empno, ename, sal in EMP block and sal, sum(sal) are in EMP1 block, i set the property for sum is summarized block is: EMP1 and item is SAL, i want display sum(sal), but not display when i click execute query..
please please help how to fix this issue..
Thanks,
Siva
-
Attachment: image1.png
(Size: 80.05KB, Downloaded 773 times)
|
|
|
|
|
|
|
Re: Total field from another Block [message #587361 is a reply to message #587358] |
Fri, 14 June 2013 07:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/72104.gif) |
Littlefoot
Messages: 21818 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
- create the first, database block, containing all items from the EMP table
- set its "Query all records" property to "Yes"
- create another, control block
- set its "Single record block" property to "Yes"
- create a NUMBER datatype non-database summary item
- set its Calculation properties to:
- calculation mode = summary
- summary function = sum
- summarized block = <name of the first block>
- summarized item = sal - run the form
- execute query
- summarized salaries will be displayed in a summary item
|
|
|