Hi all,
I am want a report such that
1. if user does not enter months he has to get last 24 months data(from current month)
eg1.
-
Sales
currentmonth 300
currentmonth-1 400
.............................
currentmonth-20 500
2. if user enter months he has to get required months data(from current month)
eg1.assume that user entered the interval of last two months.
-
Sales
currentmonth 300
currentmonth-1 400.
friends please me in desinging this query.
It's very urgent,waiting for responses.
Thanks,
James.