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

Solution:

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

Go to property pallet (right click > property pallet or click F4) of the block where you used summary function as item.

Change Query All Records to "YES"
and Precompute Summaries to "YES".

Related Queries:

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.
-----------------------------------------------
FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes.

I am getting this error, when I compile the form. Though I have set the Query All Records to Yes, in the item, as Calculation mode to Summary, Summary Function to Sum and specified the datablock, and item to which needs to be totaled.
------------------------------------------------
FRM-30425: Summarized database item must reside in a block with Query All Records or Precompute Summaries set to Yes.
Item: TOTAL
Block: SALE_DETAIL
FRM-30085: Unable to adjust form for output.
------------------------------------------------