Friends,
I need to sum a running sum in report.
I used
SELECT T1.SRNO, T1.TOTAL, (SELECT SUM(PFINTQ.TOTAL) AS CUMTOT
FROM PFINTQ
WHERE PFINTQ.SRNO <=T1.SRNO ) AS CUMTOT, T1.[PF NO], T1.DATE, T1.UNIT_NAME, T1.DESGN, T1.OBAL, T1.SUBSCRIPTION, T1.VDPF, T1.REFUND, T1.WITHDRAWAL, T1.LEDG_NO...