| Summary Item problem [message #151623] |
Thu, 15 December 2005 21:46  |
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
|
Member |
|
|
Hi
I am using Oracle Forms 6i.
I have 3 database Blocks.
1. HEADER
2. DETAILS
3. SUB DETAILS
Block SUBDETAILS is linked with DETAILS.
Now whenever I try to Have a Summarised column in my DETAILS BLOCK.
It gives an error.
As in I wish to show TOtal of AMount.
I use a NON-DATABASE-ITEM with calculation-SUMMARY
My SUmmarised Item is in DETAILS BLOCK.
PRE-COMPUTE set to NO
QUERY ALL set to Yes.
Still cannot Use the SUMMARY FUNCTION.
Howevere when I delete from SUB DETAILS Block It works fine.
Can someone explain why this happens.
And any solution to this.
p.s: I dont want to write a loop to calculate my Total Amount.
Thks
Atul P
|
|
|
|
|
|
| Re: Summary Item problem [message #151694 is a reply to message #151669] |
Fri, 16 December 2005 03:41  |
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
|
Member |
|
|
I have 3 blocks
HEADER
DETAILS
SUB_DETAILS (Linked with DETAILS)
NOw in DETAILS Block I have
Fields as below
DATABASE FIELD
TRND_AMOUNT -> Not Displayed
NON DATABASE FIELDS
NBT_AMOUNT -> Data Entered through Screen
NBT_A_AMOUNT -> Calculation (Formula Based :NBT_AMOUNT * N1)
NBT_B_AMOUNT -> Calculation (Formula Based :NBT_AMOUNT * N2)
Now at Bottom I wish to Show Summary for
All above four fields.
For
TRND_AMOUNT -> There is no error
HOwever when I want to show Summary using
Calculation-Summary for NBT_AMOUNT, NBT_A_AMOUNT, NBT_B_AMOUNT
then it shows following ERROR:
----------------------------------------------------------
FRM-30427: Summarized control item cannot reside in a block with Precompute Summaries set to Yes.
Item: NBT_TOT_A_AMT
Block: DETAILS
FRM-30085: Unable to adjust form for output.
----------------------------------------------------------
ABove conditions have been taken care off.
Still cannot get rid of the error.
Hwever if i remove the SUB_DETAILS BLOCK then the Error is not coming and I can RUN THE FORM.
hope this should be sufficent to put forward my problem.
Thks
Atul
[Updated on: Fri, 16 December 2005 03:46] Report message to a moderator |
|
|
|
| Re: Summary Item problem [message #151702 is a reply to message #151694] |
Sun, 18 December 2005 07:35 |
sachinjainonweb
Messages: 24
Registered: October 2005
|
Junior Member |
|
|
Hi Atul,
Try this
DETAILS block properties:-
Pre-compute Summary -no
Query All Reords:-Yes
Make another block just to hold summary of the four fields, say CTRL block
CTRL block properties:-
single record -Yes
Query All Reords:-Yes
Pre-compute Summary -no
Database Block :-no
and four summary items in CTRL block , with
Calculation mode:- Summary
Summarized Block:-DETAIL
Summarized Item:-Items of Detail Block
Luck Always
|
|
|
|
|
|
| Re: Summary Item problem [message #152395 is a reply to message #151954] |
Thu, 22 December 2005 21:12 |
Atul P
Messages: 61
Registered: June 2003
Location: Mumbai-Jakarta
|
Member |
|
|
Problem Solved !!!!!!!!1
the Problem has been solved.
I had POst-Change Trigger on the DETAILS Block to fetch
Description for some codes.
After getting rid of those POST-CHANGE triggers it works.
Thks
Atul P
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
