Page 1 of 1
Sort function sort alphanumeric instead of numeric
Posted: Wed Nov 23, 2016 4:32 pm
by Kryshik
Hello Stimulsoft support team,
I've created a report and wanted to sort it by an index value, which is in the report.
This index value is defined as an integer, but if I sort the report by the index descending, the report list "18" below "2. See attached picture.
Should I set some more settings or values?
Greets Kryshik
Re: Sort function sort alphanumeric instead of numeric
Posted: Thu Nov 24, 2016 7:25 am
by HighAley
Hello.
Could you send us sample data that will help us to reproduce the issue?
Thank you.
Re: Sort function sort alphanumeric instead of numeric
Posted: Thu Nov 24, 2016 9:02 am
by Kryshik
Hi HighAley,
Thank you for the sample data request. By the preparation of the sample data, I saw that in the schema the type is still on string I changed it to int and now I got the right sorting!
Greets Kryshik
Re: Sort function sort alphanumeric instead of numeric
Posted: Thu Nov 24, 2016 9:03 am
by Kryshik
Hi HighAley,
Thank you for the sample data request. By the preparation of the sample data, I saw that in the schema the type is still on string I changed it to int and now I got the right sorting!
Code: Select all
<xs:element name="LINK_SUPSW_has_assigned_threat">
<xs:complexType>
<xs:sequence>
<xs:element name="Actual_risk_index" type="xs:int" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
Greets Kryshik
Re: Sort function sort alphanumeric instead of numeric
Posted: Thu Nov 24, 2016 9:52 am
by HighAley
Hello, Kryshik.
The data are sorted as in your data source when you select sorting column this way.
Or you should specify the DataSource1.Calumn1 as expression, then the data will be sorted as specified in the Dictionary.
Thank you.