Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running summary in oracle reports 2.5

Status
Not open for further replies.

jayarammv

Programmer
Nov 26, 2001
2
0
0
IN
Can somebody tell me how to achieve a Running summary in oracle reports, just like we have in Access reports? Or how to build a query which will have running sum of a column?
like
Column Running Summary
1 1
2 3
3 5
 
If you have 8i or up you can use something like

SELECT date, amount, SUM(amount) OVER (ORDER BY date)
FROM table

to get the amount and then the cummulative sum of amount by date.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top