Dynamic Reports and Interactive Charts. A powerful tool for report creation and data analytics in SugarCRM. Includes a variety of chart types, detailed, summary and pivot tables. This Reporting Tool is very user-friendly, no need for technical knowledge or SQL. The Sapiens.BI tool comes with over 100 pre-built reports that are ready to be used on day one.
#3368 - Data Export issue in xls and pdf
Dear IT Sapians Great Team,
Hope you will be doing well. I am facing an issue in exporting data. As now my database have many records. On of my table has around 50K records. When i export all data with your plugin, It gives error This page isn’t working
Can you please help me, what should i do to fix this out?
Thanks in advance
-
"Outstanding plugin with great support. I am a happy customer."
Read More Reviews
- Most Recent Love from Users
Sohaib Majeed- kisan
- dion
- chanelreb
- Doug Mosher
- chanelreb
6 years ago
Dear Team, Any update on above issue?
6 years ago
Hello Sohaib,
It is recommended not to Export such a large reports to Excel and try to limit output with filters.
However, if you still really need it, here is what you can try: Usually when a larger report fails to output the Excel it has to do with the lack of memory that is allocated to php / Sugar. To increase the memory amount open config.inc.php in your Sugar instance root directory. You should look for a line ini_set('memory_limit', followed by the memory limit setting.
Simply change the line to ini_set('memory_limit','1G'); and try to generate the Excel file again.
Best Regards, IT Sapiens Team