Running sum... in Report...

[akumar118]

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, T1.FOL_NO, T1.SUBSCRIPTION, [CUMTOT] AS CUMTSM
FROM PFINTQ AS T1;

in querry. then I created a report using the query.

Now I want to total the column CUMTOT in the page footer.i.e. Grantd Total

 

[HiTechCoach]

See:

Report Page Totals (Download ReportPageTotals.zip)
An example report which shows two methods of displaying page total calculations.

from:
http://www.databasedevelopment.co.uk/examples.htm

 

[akumar118]

I downloaded the file and went through the report file.
Well,What I need is :

As mentioned earlier in query i calculated a cumulative field of total in a new filed CUMTOT. In the report I placed the CUMTOT field and set the value asl RUNNING SUM OVER ALL.

Now I want to sum this CUMTOT in the page footer or Report Footer.

I tried to use Sum function, but it gives me error MULTILEVEL group by clause not possible.

Hope problem is understood.