Page 1 of 1
running balance in report 6i/9i
Posted: Thu Jan 25, 2007 1:58 am
by patelwork
received. total
------------ -- ------------ -
10 10
20 30
30 60
also same with debit-credit
thank you
Posted: Thu Jan 25, 2007 2:19 am
by ahmadbilal
SELECT ENAME, DEPTNO, SAL,
SUM (SAL) OVER (ORDER BY DEPTNO, ENAME) "Running Total"
FROM EMP
ORDER BY DEPTNO, ENAME
Posted: Thu Jan 25, 2007 3:05 am
by admin
Dear patelwork,
Your question is not clear and provide detail. We should avoid incomplete questions. thanks
Posted: Thu Jan 25, 2007 3:26 am
by 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
Posted: Thu Jan 25, 2007 6:11 am
by ahmadbilal
there two ways
one i already posted
second by using report summary column
Posted: Thu Jan 25, 2007 11:00 am
by patelwork
can u plz tell me the second way.
Posted: Tue Feb 13, 2007 10:33 am
by 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)