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

Edit report at https://bugs.php.net/bug.php?id=36959&edit=1 ID: 36959 Comment by: syerif at gmail dot com Reported by: djogopatrao at gmail dot com Summary: ReadRecords Method (Crystal Reports XI) Hangs Status: Not a bug Type: Bug Package: COM related Operating System: Windows XP PHP Version: 5.1.2 Block user comment: N Private report: N New Comment: I have problem with set parameterFields SetCurrentValue in date format anybody can help me? Previous Comments: ------------------------------------------------------------------------ [2010-03-12 08:49:41] girlmauhong85 at yahoo dot com i work with Crystal Report 10 and i work only onnce time. When i try again, i get the following error:Fatal error: Uncaught exception 'com_exception' with message '<b>Source:</b> Crystal Reports ActiveX Designer<br/><b>Description:</b> Unbekannter Abfragemodulfehler' in C:\xampp\htdocs\neu\BescheinigungPDF.php:28 Stack trace: #0 C:\xampp\htdocs\neu\BescheinigungPDF.php(28): variant->LogOnServer('p2sifmx', 'name', 'name', 'acc', 'pass') #1 C:\xampp\htdocs\neu\BescheinigungPDF.php(123): BescheinigungPDF->getPDF('20062', 99898989) #2 {main} thrown in C:\xampp\htdocs\neu\BescheinigungPDF.php on line 28 my code: function getPDF($sem,$mtknr){ // Create an Crystal Object Factory. $o_CrObjectFactory = new COM('CrystalReports10.ObjectFactory.1')or die ("Error on load"); try { $o_CrApplication = $o_CrObjectFactory->CreateObject("CrystalRunTime.Application"); } catch (com_exception $e){ echo("<br>Error on instance creation:<br>".$e->getMessage().'<p>'.$e->getTraceAsString().'</p>'); echo "<p><pre>".print_r($e, true)."</pre></p>"; exit; } // Register the typelibrary. com_load_typelib('CrystalDesignRunTime.Application'); // Load the report. $o_CrReport = $o_CrApplication->OpenReport('C:\xampp\apache\Studienbescheinigung.rpt', 1);// 1== crOpenReportByTempCopy. $o_CrReport->Database->LogOnServer('p2sifmx', 'name', 'name', 'acc', 'pass'); $o_CrReport->DisplayProgressDialog = False; $s_ExportedReport = 'C:\xampp\apache\test.pdf'; var_dump($o_CrReport->RecordSelectionFormula); $str = "{sossys.aktsem} = $sem and {sos.mtknr} = $mtknr"; $o_CrReport->RecordSelectionFormula=$str; var_dump($o_CrReport->RecordSelectionFormula); // Run the report and save the PDF to disk. $o_CrReport->ExportOptions->DiskFileName = $s_ExportedReport; $o_CrReport->ExportOptions->PDFExportAllPages = true; $o_CrReport->ExportOptions->DestinationType = 1; // Export to File $o_CrReport->ExportOptions->FormatType = 31; // 31 = PDF, 36 = XLS, 14 =DOC $o_CrReport->EnableParameterPrompting = 0; $o_CrReport->DiscardSavedData; //remove die saved Datei $o_CrReport->ReadRecords(); //force it to update the data in the report from the ADO.command,(Does not work). $o_CrReport->Export(false); $o_CrReport=null; $o_CrApplication = null; $o_CrObjectFactory=null; print "...done"; var_dump($o_CrReport->RecordSelectionFormula); /*****/ } My chef think, i shoul programm in java but every thing i worked with php(my programm work for an card terminal). Should i make an connection between php and java to call my crystal report? Please help me, thank you very much!!! ------------------------------------------------------------------------ [2008-11-27 13:21:40] djogopatrao at gmail dot com Hello Please refer to my previous comment at 3 Apr 2006, in which I tested the same code with PHP-CLI and it worked fine, but without any pop-ups. When generating the report from CR, no pop-ups appeared too. That particular rpt file had all the connection information. I also remember that it wasn't related to some connection problem - if the settings were incorrect, it would throw a exception instead of hanging. It was 2 years ago, and I don't know anymore where the bug setup files are, but if you wish I can spend some time looking for it. ------------------------------------------------------------------------ [2008-11-27 11:22:20] pajoye@php.net not a bug > bogus ------------------------------------------------------------------------ [2008-11-27 11:06:30] hummerok at gmsil dot com 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 ------------------------------------------------------------------------ [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 ------------------------------------------------------------------------ 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 https://bugs.php.net/bug.php?id=36959 -- Edit this bug report at https://bugs.php.net/bug.php?id=36959&edit=1