OraFAQ Forum: Forms » how use sumry column in form

Home » Developer & Programmer » Forms » how use sumry column in form

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how use sumry column in form [message #173924]

Thu, 25 May 2006 04:48

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

sir i need Summarized in my form after grid
i put one column and set property calcution mode Summarized
and function sum
block name detail block name and field

but when i run from system give me this error

FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes.
Item: ALLTOTAL
Block: VOUDETAIL
FRM-30085: Unable to adjust form for output.

please give me idea

thank

Report message to a moderator

Re: how use sumry column in form [message #173936 is a reply to message #173924]

Thu, 25 May 2006 05:19

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Forms already gave it to you:

FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes.

Report message to a moderator

Re: how use sumry column in form [message #173940 is a reply to message #173936]

Thu, 25 May 2006 05:38

mfa786
Messages: 210
Registered: February 2006
Location: karachi

Senior Member

sir
i do not understand with your reply

which property i set for right result

please give me idea clearly

thanking you

Report message to a moderator

Re: how use sumry column in form [message #173948 is a reply to message #173924]

Thu, 25 May 2006 06:07

adnanykhan
Messages: 4
Registered: May 2006
Location: PAKISTAN

Junior Member

set block propery (query all record to YES) for the block where summary column exists

Report message to a moderator

Re: how use sumry column in form [message #173949 is a reply to message #173940]

Thu, 25 May 2006 06:19

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

It says that summary column must be an item of a block whose
- Query All Records or
- Precompute Summaries
are set to "YES". Check the attached image.

Attachment: summary_item.jpg
(Size: 80.06KB, Downloaded 3380 times)

Report message to a moderator

Re: how use sumry column in form [message #173953 is a reply to message #173949]

Thu, 25 May 2006 06:34

Maaher
Messages: 7065
Registered: December 2001

Senior Member

mr "see my error", I have - again - deleted a duplicate post from your hand. It is not the goal of this forum to have it filled with twin topics. Could you please stick to one and one post per topic?

thanking you

MHE

Report message to a moderator

Previous Topic:	enter only characters and . and _
Next Topic:	make a master and detail for the same table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:42:34 CDT 2024