Unable to Export Reports

[helpdesk@tidiproducts.com]

All,

I've just recently moved my SugarCRM Pro installation to a new server. On the new server I am running Windows Server 2008 64-bit, IIS 7 with PHP 5.2.10 and MySQL 5.1.

When I go into the reports tab I am able to run any custom or built in report without a problem. However, when I try to export that report it comes back after a couple minutes and says that it was unable to download the report. The server connection was reset.

Does anyone have any ideas what would cause this to happen? I've been pulling my hair out over it and I need to get these reports running ASAP!

Any help provided is very much appreciated!!!

Regards,

Jason

[kebabman]

I'd be quite interested to know any ideas on this as well. We have a similar problem on a CE installation. The problem is not confined to exports either. If we upload an attachment and subsequently try to download that attachment it doesn't work either.

[helpdesk@tidiproducts.com]

After working with a support rep we were able to determine that it is a bug and there was one pre-existing that was documented with the fix. Below is the link to the fix for this item.

http://www.sugarcrm.com/crm/support/...g_number=33008

Hope this helps!

Regards

[kebabman]

Thanks for that. Maybe I'm being stupid but I can't seem to find the fix from that link, just a description of the bug Obviously the fix would be quite useful

[helpdesk@tidiproducts.com]

My bad, they included the fix in an email message that was sent to me. It didn't actually display the fix in the bug. Didn't realize that until I actually looked at the link after posting it. The fix is as follows:

As explained in the bug description, you can comment out the following code from the "export.php" file: ----- Please be sure and make a backup of this file before editing -----

/*
header("Content-Length: ".strlen($content)); */

Now there is one catch to this that I found. This fixes the export problem when you try to export a list of contacts or accounts, for instance, from the listview of their respective modules. If you try to export a report, it still does not work. I'm hoping I'll hear something back from them soon on this.

Regards

[kebabman]

Brilliant, thanks for that. It seems to be working now

[wichard]

Now there is one catch to this that I found. This fixes the export problem when you try to export a list of contacts or accounts, for instance, from the listview of their respective modules. If you try to export a report, it still does not work. I'm hoping I'll hear something back from them soon on this.

Regards

I had the same problem, what fixed is for me is the following:

Open /modules/Reports/templates/templates_export.php
and on line 76(depending on your version) disable the following

header("Content-Length: ".strlen($content));

This way the browser won't be able to show a progres bar but at least the file can be downloaded.

This error seems to be trigger by something in the environment, the same sugar with the same data works on one machine and on another it needs this workaround.