FastReport: Save as Excel 2007 file (.xlsx) VS XML (Excel) table .xls

118 Views Asked by At

Good day everyone, I have a question about compatibility of Excel-type files in FastReport (version 2020.1.17):

Our company uses FastReport tools to create reports and integrate them into e-docs system. When the report is build, we have a selection of formats to save from, including excel formats (specifically .xlsx for Excel 2007 option and .xls - for XML (Excel) table enter image description here

The problem is that when the client chooses to build report between 18.09.2023 and 25.09.2023 (is inputed manually through form) using Excel 2007 option, it goes with this: enter image description here

Table is being built normally when we specify period from 04.09 to 15.09. Same goes with XML (Excel) table and .xls format, but this time report looks normal regardless of inputed period.

Code tab lookd like this: enter image description here

Perhaps I should add some code to solve this problem, but I am not very skilled in C# or maybe there are special plugins, so please, help. Thanks.

Searched through plugins, code solutions, russian-english manual but to no avail

1

There are 1 best solutions below

1
M. Ahmad Uzair On

You're facing an issue with FastReport when generating Excel reports for a specific date range. Check date format compatibility, investigate code logic for errors, and debug if needed. Verify data quality and consider software updates or alternative export formats. Ensure language and localization settings are correct, and test with various date ranges to pinpoint the problem. Reach out to FastReport support or community for assistance if necessary.