sorting expressions (columns) in aplhabetical order

[#1]

Hi,

I'm hoping there is a solution to this as it's driving us crazy.

We have a very big straight table with about 60 columns (done in reponse to a table box not being able to cope with data); however, the expressions definitions don't seem to be in any order. If causing a lot of difficulty and time when trying to find a column. We want it in alphabetical order

There isnt the 'text order' option in a table box and existing fuctions of 'sort' within the staright table doesnt seem to actually sort the data. Here is current setup:

You can see even picking text 'a-z' its still not in order:

[Anonymous · Accepted solution]

That would not be possible...

But yes, you can promote or demote your expression in alphabatically order

[MK_QSL]

You have to go to Expressions tab and try to sort manually by Promote and Demote option..

[jagan]

Hi,

In Expressions tab you have to manually sort by using Promote and demote buttons.  No other way for this.

Regards,

Jagan.

[jonathandienst]

According to your screen shot, the field with the highest sort priority is Void Cost, which sounds like a numeric field. Sorting this alphabetically may give inconsistent results. Promote Address to the highest priority (in the dialog or interactively on the chart) and ensure that field is A-Z sorted.

[amit_saini]

Hi Chris,

Sorry this is not possible, only option is to promote or demote as Balraj suggested.

But let's wait for other views on this.

Thanks,
AS