Seeking your assistance to figure out the reason behind this error,
Upon generating a report into excel file, The generated file has 0 bytes
and when opening the file the excel give as this king of error,
May we know the cause of this error?
Have you reviewed the below suggestions https://www.stellarinfo.com/article/excel-cannot-open-the-file-because-the-extension-is-not-valid.php#:~:text=If%20the%20'Excel%20file%20extension,Versions%2C%20click%20Recover%20Unsaved%20Workbooks.
Also, I recommended to re-install the excel again in the system, the issue related to the excel version.
Could you please export the report into PDF and convert it into excel and check the issues?
I’ve also seen this happen if you try to open the Excel file before it’s finished downloading. If it’s a large report, it may take a moment or two to finish downloading completely.
I tried to follow the instruction but still not working, but I tried to filter to lessen the output and its working but when I go back and generated the whole report. The error is still there.
Do you have any workaround available for this issue?
You have answered the cause of your Excel error: too many records being exported.
You have asked for a work-around. One work-around is to filter your records and export them in smaller groups. For example, you may filter by financial period and export a few periods at a time.
Another work-around is to use an Export Scenario to export the records. We can export to CSV when there are too many records for Excel.
Would you give us a reference on how to used export scenario in a report designer?
Hello, Export Scenario isn’t part of report Designer. Export Scenarios are part of Integration module.
We can import from Excel using Import Scenarios, and similarly, we can export to excel using Export Scenarios. YouTube is a good resource to see examples.
Hi Miss Laura, The Excel that I want to export in excel is a report type not a field type maybe there is a limitation for Export By Scenario and there is a possibility that the requirement of the report might not be the same. Thanks!