running balance in report 6i/9i

[patelwork]

received. total
------------ -- ------------ -
10 10
20 30
30 60

also same with debit-credit

thank you

[ahmadbilal]

SELECT ENAME, DEPTNO, SAL,
SUM (SAL) OVER (ORDER BY DEPTNO, ENAME) "Running Total"
FROM EMP
ORDER BY DEPTNO, ENAME

[admin]

Dear patelwork,
Your question is not clear and provide detail. We should avoid incomplete questions. thanks

[patelwork]

sory for that...

i need running balance in report as like

rec qty total qty
------- ----------
10 10
20 30
30 60

as the right column shows the prvious qty+current qty.
hope it clear now.
waiting ur response
thank you

[ahmadbilal]

there two ways
one i already posted
second by using report summary column

[patelwork]

can u plz tell me the second way.

[imranhad]

sory for that...

i need running balance in report as like

rec qty total qty
------- ----------
10 10
20 30
30 60

as the right column shows the prvious qty+current qty.
hope it clear now.
waiting ur response
thank you


<i><div align="right">Originally posted by patelwork - 24/01/2007 : 10:26:36 PM</div id="right"></i>

try this one

select rec,sum(qty)
from table
group by rollup(rec)