xampivotgrid is sorting numbers as strings

3160

Sam posted over 12 years ago

Is sorting: 1, 1.5, 10, 2

Should sort 1, 1.5, 2, 10

igFlatData:FlatDataSource x:Key="QtyFlatData" x:Shared="False" PreserveMembersOrder

="False"

Rows

="[Collateral].[Collateral],[AcctNo].[AcctNo]"

Columns

="[Type].[Type],[Coupon].[Coupon]"

Measures

="Qty"

<igFlatData:FlatDataSource.ConnectionSettings

<igFlatData:FlatDataConnectionSettings ItemsSource="{Binding Items

}"/>

</igFlatData:FlatDataSource.ConnectionSettings

<igFlatData:FlatDataSource.CubesSettings

<igFlatData:CubeMetadata DataTypeFullName

="Poolman.Models.ExposureItem">

<igFlatData:DimensionMetadata SourcePropertyName="Qty" DisplayFormat

="{}{0:#,#;(#,#)}"/>

</igFlatData:CubeMetadata

</igFlatData:FlatDataSource.CubesSettings

<igFlatData:FlatDataSource.LevelDefaultSortDirections

<igFlatData:LevelSortDirection LevelUniqueName="Collateral" SortDirection

="Ascending" />

<igFlatData:LevelSortDirection LevelUniqueName="Coupon" SortDirection

="Ascending"/>

</igFlatData:FlatDataSource.LevelDefaultSortDirections

<igFlatData:FlatDataSource.HierarchyDescriptors

<igFlatData:HierarchyDescriptor SourcePropertyName="Collateral" HierarchyName

="Collateral" >

<igFlatData:HierarchyDescriptor.LevelDescriptors

<igFlatData:HierarchyLevelDescriptor LevelName

="All"/>

<igFlatData:HierarchyLevelDescriptor LevelName="Description" LevelExpressionPath="Collateral"

</igFlatData:HierarchyDescriptor.LevelDescriptors

</igFlatData:HierarchyDescriptor

Parents

Reply

Children