Stimulsoft Business Intelligence System | Forum

Before we make update all date colums was as string in Stimulsoft and date Sorting was working.

After Update date colum is also string but now it sorting like a realy string.
So we must edit all reports to change date colum from string to datetime.

Is it a easier way to do this ?

Thanks for help

Best regards Peter

Hello Peter,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

Hi Lech

Its simple to reproduces the issue.
We have in Datatables a field named "date" (its realy a date field but in all reports its a string datatype)

When i have a datatable and make sorting by date (datatyp = string) sorting = wrong
When i habe a datatable and make sorting by date (datatyp = datetime) sorting = working

In older Versions it was working correct and also when datatyp = string sorting correct. I think it automaticly checked its a datetime datatype.
In new Version it use this as string and sorting is wrong.

The Solution is to change all Reports with field date from string to datetime. But we habe so many reports so it will be very difficult to change all reports.

Sorting date as datetime = correct:
2024-04-28
2024-04-29
2024-04-30
2024-05-01
2024-05-02
Sorting date as string = wrong
2024-05-01
2024-05-02
2024-04-28
2024-04-29
2024-04-30

Perhaps is a solution, so we don't change all Reports.

Thanks Peter

Hello Peter,

We couldn't reproduce the issue on our test data.
Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.

Hi Lech,

I was also able to reproduce the error.
Attached is an example report.


Date field (not working):


Sort not working:


Date field (working)


Sort working with correct date field:


Thanks in advance.
Florian

Hello,

Please send us test data for your report.

Thank you.

Hi Lech,

here I send you the report including the data.

Thanks in advance.
Florian

Hello,

It is the rendered report.
Please send us a sample report with test data that we can check and run, and reproduce the issue.

Thank you.

Hi Lech,

here I send you the report and the data.

Thanks in advance.
Florian

Hello,

Thank you for the sample. We need some time to investigate the issue.

Thank you.
#14499