shivareddyk Posted June 29, 2009 Share Posted June 29, 2009 hi ...... how to compare current month data with last month data from I-Reports designer?(i need to calculate both in same report) how to cummulative data from I-report designer? pls,let me know.......... BestRegardsshi va Link to comment Share on other sites More sharing options...
baggypants Posted June 29, 2009 Share Posted June 29, 2009 I did this in SQL if your database supports OVER it.In OracleSELECT month, SUM(amount) AS month_amount, SUM(SUM(amount)) OVER (ORDER BY month ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS cumulative_amount Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now