Sort function sort alphanumeric instead of numeric

[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

[HighAley]

Hello.

Could you send us sample data that will help us to reproduce the issue?

Thank you.

[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

[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

[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.