Change month number to name NOT in SQL but in list box

[#1]

I have an inherited SQL script that works fine to give me a field "Month", which contains 1-12. Naturally, on reports, I'd prefer to show the month name. First, I tried doing it SQL, but the result was the month names (fine), but in a random order. No matter what I picked in the "Sort" property in the list box, they wouldn't come up in month order (alphabetical? sure. state? sure. but calendar order? No.)  Within the "Month" (number) list box, I tried the expression = Pick(Month, $(MonthNames)) but that didn't change it. Is there away to do this in the Listbox and not in SQL?

[yvesqlik · Accepted solution]

bevoryou load your data from sql, you have to create a dual

load dual(String,Num) as Month inline

[String,Num

Jan,1

Fev,2

Mar,3

Apr,4

Mai,5

.

.

.

.

Dec,12

];

here you can load you data and use the fied Month.

und now you can use the name of month in your listbox.

Let me know if my solution help can help u.

best regards

[#3]

Thanks, yves, that worked just fine.