Hi,
Correct me if I'm wrong.
What you need is the order for the report as 'Apr07, May07, ..., Mar08, Apr08'. Is it correct?
In this case, create a formula (as text) which contains yyyymm.
So it will sort by Year and month (and date if you need it).
Then sort the report based on this formula.
e.g.:
Totext(Year(datevar),0,'')+
if (Month(datevar))<10 then
'0'+totext(month(currentdate),0,'')
else
totext(month(currentdate),0,'')
Note: change 'datevar' with your variable/field.
The result will be something like '200704' or '200711'.
Then you can sort the report using this formula.
In the report hide this formula and put the date variabel.
So, it will printed as 'Apr2007', 'May2007', ..., 'Jan2008', etc.
hope it help.
Edited by Emir_W - 17 May 2010 at 2:39am
IP Logged
