Is there a way to increase the number of rows Sage Intelligence will render to Excel? Modern versions of Excel allow over a million rows of data on a sheet, so why is SI restricting the number of rows to 50 000?
Is there a way to increase the number of rows Sage Intelligence will render to Excel? Modern versions of Excel allow over a million rows of data on a sheet, so why is SI restricting the number of rows to 50 000?
Hi Mathew,
Am not aware of any restricitions from SI side, what report is this and does it give any error?
Hi Desree. Thanks for responding.
It is the same for any report, but for example, the Sales Master Detail report is Sage 200 Evolution. If your date range is such that the number of rows returned by the query exceeds approximately 50 000 rows, SI returns an error when rendering the data to Excel, as shown in the attached screen shot. This means that the client is unable to analyse the sales history, in detail,for a full year in one report.
Hi Mathew
This is then most likely a memory issue. Check the amount of available memory on that PC, then try running the same report on another machine with more memory, it should run out.
Hi Mathew
This is then most likely a memory issue. Check the amount of available memory on that PC, then try running the same report on another machine with more memory, it should run out.
*Community Hub is the new name for Sage City