custom order of column

[div_1234]

hi

i want to arrange column in specific order.

i created new data item

my expression r like


case[col]

when 'quantity' then 1
when 'sale' then 2
when 'min' then 3
when 'max' then 4

End

after that i click that query item and make that field to ascending order.

now the field r coming like 1 , 2 ,3, 4 in report,but i want  quantity,sale,min,max

how to do that?

[MFGF]

Leave the original column in your list and sort it based on your new column. 

Regards,

MF.