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: 14
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
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: 20827
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"?
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: 14
Registered: December 2008
Location: Ludhiana
Junior Member

yes i try it already
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: 20827
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What happened when you did that?
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: 14
Registered: December 2008
Location: Ludhiana
Junior Member

same errot i got. and if i delete the the 3rd block then its working fine.
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: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Sorry that I have been so long in replying. Have you solved your problem?

David
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: 14
Registered: December 2008
Location: Ludhiana
Junior Member

no my dear i m facing still the same problem Sad
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: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Setting output path
Next Topic: List item issues
Goto Forum:
  


Current Time: Tue Sep 27 21:13:09 CDT 2016

Total time taken to generate the page: 0.08958 seconds