PHP and Crystal Report 8.5

[kirkb]

I am a new at PHP and I am trying to get PHP and Crystal 8.5 to cooperate but it works sometimes about three to four times and then I keep getting the ambiguous 'Server not yet opened' error message.

I have been Googling for days without much success.

My code is below can anyone point me in the right direction please. I am using PHP 5.

<?php

$cr_report = "C:\\wamp\\www\\site\\Report1.rpt";
$exp_pdf = "C:\\wamp\\www\\site\\test1.pdf";

$ObjectFactory= New COM("CrystalRuntime.Application.8.5");
$creport = $ObjectFactory->OpenReport($cr_report, 1);

$creport->ExportOptions->DiskFileName=$exp_pdf;
$creport->ExportOptions->PDFExportAllPages=true;
$creport->ExportOptions->DestinationType=1;
$creport->ExportOptions->FormatType=31;
$creport->Export(false);

$len = filesize($exp_pdf);
header("Content-type: application/pdf");
header("Content-Length: $len");
header("Content-Disposition: inline; filename=$exp_pdf");
readfile($exp_pdf);

?>

[kirkb]

Ok, so I upgraded from Crystal 8.5 to Crystal 11. What happens now is this, the Crystal report is only displayed in the browser when it is saved with data.

Whenever I try to pass parameters to refresh the report to it hangs. Any ideas as to how to jump this hurdle anyone?

The code I am using is below:
<?php

$cr_report = "C://wamp//www//site//report3.rpt";
$export_pdf = "C://wamp//www//site//reportin.pdf";

$ObjectFactory= New COM("CrystalReports11.ObjectFactory.1");
$crapp = $ObjectFactory->CreateObject("CrystalDesignRunTime.Application");
$creport = $crapp->OpenReport($cr_report, 1);

$creport->EnableParameterPrompting = 0;
$creport->DiscardSavedData;

$creport->ReadRecords();
$zz= $creport->ParameterFields(1)->SetCurrentValue("ANDREAG");

$creport->ExportOptions->DiskFileName=$export_pdf;
$creport->ExportOptions->PDFExportAllPages=true;
$creport->ExportOptions->DestinationType=1;
$creport->ExportOptions->FormatType=31;
$creport->Export(false);

$file_len = filesize($export_pdf);
header("Content-type: application/pdf");
header("Content-Length: $file_len");
header("Content-Disposition: inline; filename=$export_pdf");
readfile($export_pdf);

//------ Release the variables
$creport = null;
$crapp = null;
$ObjectFactory = null;
?>

[kirkb]

got it!

[adnyana112]

How the solution, if you dont mind, can you tell how got it? cause now i confuse to connect php to crystal report....

thx

[seandisanti]

lol, good job figuring it out on your own, but please post your findings so the thread may be of use to others with the same challenge.

[monty]

My name is Monty and i am newbie to php just would like to know how to call crystal report passing query from php.I have used reportobject->SQLQuery($query) but getting error Unable to lookup SQLQuery.Is there any other wat to pass query to crystal report using php.