What would cause a quick report to lock-up IFS when exported to Excel? I have a quick report that if viewed in IFS, will return the results quickly, but if I try to export the quick report to excel, IFS runs and runs and eventually locks up
Best answer by BillatREM
One of your questions got me thinking. “How many records in the quick report?” While I have a parameter in the quick report to give me GL records for a given month, the report is based on a custom view which I did not write. That custom view did not have any time limits so it was producing a dataset with millions of records causing IFS to time out. I modified the custom view to only look for current year records and all works fine now.
The Quick report view only return a set number of records so I did not see the timeout there, only on the export to excel.