#36959 [Com]: ReadRecords Method (Crystal Reports XI) Hangs

ID: 36959 Comment by: hummerok at gmsil dot com Reported By: djogopatrao at gmail dot com Status: Assigned Bug Type: COM related Operating System: Windows XP PHP Version: 5.1.2 Assigned To: wez New Comment: this is not a bug. probably you have some alerts when you open this report in designer. all you need - just to update it and thos alert will gone. another reason: when you set parameters from your program you need to set $creport->EnableParameterPrompting = 0; - this also might help. I had problems like this - solved Previous Comments: ------------------------------------------------------------------------ [2008-06-06 12:53:00] rquadling@php.net Most likely this is not a bug. I've just started using Crystal XI with PHP5. One of the things that happens for me is I get a dialogue asking to login to the DB being used by the report. See http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_23463121.html#21728474 ------------------------------------------------------------------------ [2007-08-15 08:37:01] jani@php.net Assigned to the maintainer. ------------------------------------------------------------------------ [2006-05-22 15:34:57] i_geber at hotmail dot com If I would like to call a report that has parameters, how do I write the syntax? thanks ------------------------------------------------------------------------ [2006-04-03 15:41:05] djogopatrao at gmail dot com I modified slightly the code (see below, I called it hang.php) Running thru apache2, it hangs. No response from the browser (it's still "loading", started 2h ago). No entries in "error.log" since then. Commenting the $creport->ReadRecords(); line, it works. But when running by PHP CLI C:\>"Arquivos de programas\Apache Group\Apache2\bin\php.exe" hang.php C:\> It runs just fine! --------- hang.php $my_report = 'C:\Arquivos de programas\Apache Group\Apache2\htdocs\webdisc\relatorios\cadastro1.rpt'; $my_pdf = 'c:\18530.pdf'; $ObjectFactory= New COM("CrystalReports115.ObjectFactory.1"); $crapp = $ObjectFactory->CreateObject("CrystalDesignRunTime.Application"); $creport = $crapp->OpenReport($my_report, 1); $creport->ReadRecords(); //hangs here, not thru PHPCLI $creport->ExportOptions->DiskFileName=$my_pdf; $creport->ExportOptions->PDFExportAllPages=true; $creport->ExportOptions->DestinationType=1; // Export to File $creport->ExportOptions->FormatType=31; // Type: PDF $creport->Export(false); ------------------------------------------------------------------------ [2006-04-03 14:49:18] tony2001@php.net Error log entries related to the problem would be more helpful than just "hangs". Also, you can try to run the same code with PHP CLI and check for any error messages. ------------------------------------------------------------------------ The remainder of the comments for this report are too long. To view the rest of the comments, please view the bug report online at http://bugs.php.net/36959 -- Edit this bug report at http://bugs.php.net/?id=36959&edit=1