通过PHP挂起生成Crystal报表

发布时间：2020-12-13 13:26:06 所属栏目：PHP教程来源：网络整理

导读：我正在尝试使用php脚本生成水晶报告.该脚本似乎在ReadRecords()之后挂起;日志文件中不会生成任何错误消息.我做错了吗？ $my_report = "C:inetpubwwwrootmamobilereportsinvoice.rpt";$my_pdf = "C:inetpubwwwrootmamobilereportstest.pd

我正在尝试使用php脚本生成水晶报告.该脚本似乎在ReadRecords()之后挂起;日志文件中不会生成任何错误消息.我做错了吗？

$my_report = "C:inetpubwwwrootmamobilereportsinvoice.rpt";
$my_pdf = "C:inetpubwwwrootmamobilereportstest.pdf";

$ObjectFactory = new COM("CrystalReports115.ObjectFactory.1");

$crapp = $ObjectFactory->CreateObject("CrystalDesignRuntime.Application.11");

$creport = $crapp->OpenReport($my_report,1);

$creport->EnableParameterPrompting = 0;

$creport->DiscardSavedData;
$creport->ReadRecords();

$creport->FormulaSyntax = 0;
$creport->RecordSelectionFormula = "{invoice.invoiceid} = 20070128114815";

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

$creport = null;
$crapp = null;
$ObjectFactory = null;

此代码的类似版本适用于不同的报告.

$my_report = "C:inetpubwwwrootmamobilereports" . $name;
$my_pdf = "C:inetpubwwwrootmamobilereportstest.pdf";

$ObjectFactory = new COM("CrystalReports115.ObjectFactory.1");

$crapp = $ObjectFactory->CreateObject("CrystalDesignRuntime.Application.11");

$creport = $crapp->OpenReport($my_report,1);

$creport->EnableParameterPrompting = 0;

$creport->DiscardSavedData;
$creport->ReadRecords();

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

$creport = null;
$crapp = null;
$ObjectFactory = null;

这就解决了我的问题.

$my_report = "C:inetpubwwwrootmamobilereportsinvoice.rpt";
$my_pdf = "C:inetpubwwwrootmamobilereportstest.pdf";

$ObjectFactory = new COM("CrystalReports115.ObjectFactory.1");

$crapp = $ObjectFactory->CreateObject("CrystalRuntime.Application.11");

$creport = $crapp->OpenReport($my_report,1);

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


$creport->DiscardSavedData();
$creport->RecordSelectionFormula = "{invoice.invoiceid} = 20070128114815";
$creport->ReadRecords();

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

$creport = null;
$crapp = null;
$ObjectFactory = null;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!