by sapiens.bi

Dynamic Reports and Interactive Charts. A powerful tool for report creation and data analytics in SugarCRM and SuiteCRM. 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.

Free 30 day trial
Try it Now

By clicking you consent to be contacted by the developer

#3368 - Data Export issue in xls and pdf

Closed Bug? created by Sohaib Majeed 4 years ago

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?

Screenshot_14.jpg

Thanks in advance

  1. sairasarwar member avatar

    Sohaib Majeed

    4 years ago

    Dear Team, Any update on above issue?

  2. sapiens-bi member avatar

    sapiens.bi Provider

    4 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

This case is public. Please leave out any sensitive information such as URLs, passwords, etc.
Saving Comment Saving Comment...
Rating