Creating reports and dashboards | Stimulsoft community forum

Dears @ Support,

Please assist with an issue we are having. When exporting a report to an excel file and the report contains a date field, excel is not recognizing it as a proper date field. We found that we cannot properly filter the date fields. Only after making any change to the field will excel recognize it as a date field and we can filter it normally. Please see the below screenshots and attached files.

Can you please help?
Thanks in advance

Hello.

We know about this issue.
We need more time to find a solution.
We will let you know when we get nay result.

Thank you.

Ticket reference: #58

Was this ever Solved?

We are also having the same issue

Hi Any feedback regarding this fix?

Hello,

Please check the last release build.

Thank you.

Lech Kulikowski wrote: ↑Sat Aug 26, 2023 5:25 pm Hello,

Please check the last release build.

Thank you.

I have the latest build, but still does the same. What must I do different, please advise?

Set the Text Format as Date and still in Excel I can not sort?

Thank you in advance.

Hello,

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

Thank you.

Hi,

USING MSSQL as DATA Source.

Can not add example data, but added the exported Excel report and the Stimulsoft report. (Data is sensitive)

Thank you in advance.

Hello,

Please send test data for your report.

Thank you.

Lech Kulikowski wrote: ↑Wed Aug 30, 2023 9:22 pm Hello,

Please send test data for your report.

Thank you.

Can you not just use the data from the Excel Spreadsheet?

OR

How do you want the data? CSV or MSSQL Table?