jeffrey_ananta Posted February 2, 2010 Share Posted February 2, 2010 hi i'm newbie...i want to make summary report like this.. SHIPMENT REPORT / MONTH YEAR: 2010PRODUCT JAN FEB MAR APR MAY ...... TOTAL SHIPMENTA 100 120 350 450 ....... ...........B 50 75 ..... .......C 60 35 ....... ....... any idea? thanks before Link to comment Share on other sites More sharing options...
arunsankarkk Posted February 3, 2010 Share Posted February 3, 2010 Can u be more specific... i have some doubts (1) Do you have any dynamic columns..means to say all ur month columns will display for all product i guess.. if that is the case it is very simple...Plz let me know your requirement. Link to comment Share on other sites More sharing options...
jeffrey_ananta Posted February 6, 2010 Author Share Posted February 6, 2010 already solved..thanksused this query:select .... ,case extract(shipmentdate) when 1 then sum(..) else 0 end as JANfrom ...where..group by... 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