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?
Thanks!
Best answer by Laura02
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.
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.
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!
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.