Hi there,
I am struggling to run a big report successfully. The report has is based on a nl(rows) function to retrieve all customers with a sale within the last two years. For each costumer I get the turnover with different product groups (NL(sum) in the Value Entries).
This report has approximately 11'000 rows and about 28 NL(sum) functions. If I select about half of the customers I have no problems and the report finishes after about 2 hours. If I want to run the total report at once (either in the background or with the scheduler) the report is marked as finished after 3.5 hours. But when I open the report, it is still in the Design mode and no results appear.
I don't get any error messages nor are there any entires in the log of a failure (Scheduler). Is the number of NL(sum) functions in this report too big or what could be the reasons the report is not running successfully?
Thank you very much.
