This discussion is archived
0 Replies Latest reply: Apr 18, 2013 10:41 PM by ORA-00904 RSS

Oracle Calculation Summary on different levels

ORA-00904 Newbie
Currently Being Moderated
Hi Folks,

I have a little problem with my financial form. I would like to calculate some data on form so when user type some amount, the data will automatically get refreshed. This is easy done with seting calculation on item.

My form have relationship Master-Detail-Detail (BLOCK1-BLOCK2-BLOCK3).

On BLOCK2 I am displaying summary from BLOCK3 but I am unable to set summary on level of BLOCK1. Forms doesnt have such property to say reset at BLOCK1 group like reports does.

I have try to set summary on summarized item on BLOCK2 but Oracle complains and throws an exception.

I think this kind of calculation is not possible but I hope someone will convice me on the contrary.

Regards,
Igor

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points