Set sort order on simple table box

[#1]

Hi,

this sounds extremely simple - and I searched the forum, too. I just cannot believe it ...

1. How can I have a simple table box with a fixed sort order, i.e. the user cannot change the sort order by clicking the table header?

or

2. How can I use the API to set a specific column to sort order in ascending direction.

myTableBox.SortBy 2 e.g. does not set the asc/desc order. It will depend on how the columns was sorted first.

Answering either 1 or 2 will really help me. Thanks for you support.

Regards,

Georg

[hopkinsc]

Hi, i'm not sure if i understand you correctly, but if you want to stop the user from being able to sort any of the headings all you need to do is untick 'alow interactive sort' from the sort tab.

[#3]

That's what I expected. But there is no!

On the sort tab there is

• sort priority / sort by / move up / move down

and that's it!

Best regards,

Georg

[brenner_martina · Accepted solution]

Hi,

the solution is: you find 'allow interactive sort' only in a table chart, not in a table box. In a table box it is not possible to 'not allow' interactive sorting.

[stevedark]

Hi there,

Generally I find it is good to avoid table boxes as they are limited in a number of ways. To get similar functionality to a Table Box but with the ability to lock the sort order create a Chart with a type of Straight Table, add your dimensions and a single expression with just the value 1. In the presentation tab you can then suppress the expression column showing by selecting 'Hide Column'.

Once you have done this you will have the Allow Interactive Sort checkbox as described above.

Hope that helps,

Steve

[johnw]

I don't use table boxes in live applications. They're too limited for my taste. I always use a straight table intead with the hidden "1" expression like Steve mentioned.

[#7]

Thanks to all,

that was the kind of explanation I was looking for! I now know how to deal with this issue.

Best regards,

Georg

[kji]

The hiddden 1 column isnt needed if you just uncheck "Suppress Zero-Values"

[johnw]

Johan Idh wrote:The hiddden 1 column isnt needed if you just uncheck "Suppress Zero-Values"

I did not realize that. Thanks!

[#10]

Thanks Steve and John for the info.

I've tried the Straight Table and it works. However, I can't change the header of the column as it keep disable that option.

Appreciate any help.

Trisha