Month wise splitting
I did a report to get details of customers based on invoice date. Now I have to modify the report to get month wise splitting of columns based on invoice dates. In the selection screen if the user selects a range of dates for 3 months based on the invoice date i have to get data by month wise like eg...
customer no. may(price) june july
19 100 200 20
20 0 10 300. in this the output should come. how should i write the code to get month wise splitting based on invoice date. Kindly suggest.