In previous versions the PivotGrid has displayed the headers in the order they appeared in the datasource (we use FlatDataSource). This was fine, since we could controll the order of the items and hence the order of display.
With version 2011.1 the PivotGrid now sorts the headers, which gives undesired results for us. Some headers consists of alphanumeric data like "Age 1", "Age 2", ... "Age 10", "Age 11" and so on. When PivotGrid sorts these headers the order appears as strange (like 1,10,11,12,...,2,20,21,22,...).
How do we disable this sorting of the headers?
Yes, get the latest service release of 11.1 and give it a try.
so shall i download the latest or what??
Well, those two properties control the visibility of sort indicators in the UI.
If you're using 11.1 RTM that may cause the problem because in 11.1 RTM the members are sorted in ascending order by default but there were complains about that behavior so since the first service release of 11.1 we’ve removed the sorting and by default members are displayed in order of their appearance in items source.
hi, yes it is about header sortings
i already put it like this
<ig:XamPivotGrid Height="350" DataSource="{StaticResource FlatDataSource}" x:Name="pivotGrid" AllowDrop="False" AllowHeaderColumnsSorting="False" AllowHeaderRowsSorting="False"
and still its sorting the columns headers ans rows
Hello,
I suppose your question is about headers sorting and by default it is disabled so please check your settings:
<ig:XamPivotGrid x:Name="pivotGrid"
DataSource="{StaticResource flatDataSource}"
AllowHeaderColumnsSorting="True"
AllowHeaderRowsSorting="True"/>
Regards.
Plamen.