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

ID: 36959 Updated by: rquadling@php.net 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: 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 Previous Comments: ------------------------------------------------------------------------ [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. ------------------------------------------------------------------------ [2006-04-03 14:33:24] djogopatrao at gmail dot com When I say that it hangs, I mean that the browser keeps on loading the page forever, until it gets timeout. More information? I would gladly give an example report file, but as it depends on a database server and ODBC configuration, I don't know how to proceed. Please contact me if is there anything that I can do. dfcp ------------------------------------------------------------------------ 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