0 Replies Latest reply on Apr 19, 2013 5:41 AM by ORA-00904

    Oracle Calculation Summary on different levels

      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.