Home » Developer & Programmer » Forms » error FRM-30427 & FRM-30085 (oracle 9i forms 6i)
error FRM-30427 & FRM-30085 [message #444320] Sat, 20 February 2010 09:24 Go to next message
sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana
Junior Member
hello friends i m getting complie error as blow.

FRM-30427: Summarized control item cannot reside in a block with Precompute Summaries set to Yes.
Item: D_GROSS_AMT
Block: PUR_RTN_DTL
FRM-30085: Unable to adjust form for output.

i hv 3 block in a form

1. pur_rtn_hdr
2. pur_rtn_dtl
3. item_image

table 1 and 2 are relation
table 2 and 3 are relation

in table 2 i create a display item which get function sum of two fields.
and the summary item is total of that display item

pls help me out what i will do. and what i m doing wrong

if u need the tables and forms tell me i will create dump and form.

thx n regards

Report message to a moderator

Re: error FRM-30427 & FRM-30085 [message #444342 is a reply to message #444320] Sat, 20 February 2010 13:18 Go to previous messageGo to next message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
Summarized control item cannot reside in a block with Precompute Summaries set to Yes

Did you try to set this property to "No"?

Report message to a moderator

Re: error FRM-30427 & FRM-30085 [message #444344 is a reply to message #444342] Sat, 20 February 2010 13:30 Go to previous messageGo to next message
sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana
Junior Member
yes i try it already

Report message to a moderator

Re: error FRM-30427 & FRM-30085 [message #444345 is a reply to message #444344] Sat, 20 February 2010 13:32 Go to previous messageGo to next message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happened when you did that?

Report message to a moderator

Re: error FRM-30427 & FRM-30085 [message #444348 is a reply to message #444345] Sat, 20 February 2010 14:02 Go to previous messageGo to next message
sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana
Junior Member
same errot i got. and if i delete the the 3rd block then its working fine.

Report message to a moderator

Re: error FRM-30427 & FRM-30085 [message #447092 is a reply to message #444348] Thu, 11 March 2010 22:02 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

David

Report message to a moderator

Re: error FRM-30427 & FRM-30085 [message #447115 is a reply to message #447092] Thu, 11 March 2010 23:06 Go to previous messageGo to next message
sanjeev.sharda
Messages: 17
Registered: December 2008
Location: Ludhiana
Junior Member
no my dear i m facing still the same problem Sad

Report message to a moderator

Re: error FRM-30427 & FRM-30085 [message #447642 is a reply to message #447115] Wed, 17 March 2010 00:57 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Are your calculations across the record or through the block. If the latter then place them in a 'control' table as they will exist only once.

David

Report message to a moderator

Previous Topic: Setting output path
Next Topic: List item issues
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Sep 23 20:46:31 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.