Hi guys,
I've checked previous posts about similar problems, but nothing seems to work.
It is about sorting months. I have tried something from the forum: index('Mar;Apr;May;Jun',subfield(filename(),' ',2)) as MonthNum, but this doesn't sort my four months when I sort them by exression MonthNum.
We have also tried:
LOAD *
inline [Month, SortMonth
Mar,3
Apr,4
May,5
Jun,6
];
which generally sorts the months, but the selected field always moves to the top of my listbox. Also if I check "Always one selected value" (which should be the case with my report), the sorting goes to waste.
If you can give me an idea why this happens, it would be great!
Thank you!
