Membuat 'Report' Pada Codeigniter/PHP Menggunakan Crystal Reports
TS
beSync2687
Membuat 'Report' Pada Codeigniter/PHP Menggunakan Crystal Reports
THREAD PERTAMA ANE
Malem agan sista master suhu php, ane lagi nyoba bikin laporan pakek codeigniter sama crystal report, ane udah muter-muter google, ketemunya masih error mulu gan , walaupun error yang ane dapet udah agak mendingan sih, kira-kira udah 75% teratasi lah . Tapi, ane masih karena ya tadi gan, masih error.
ini error ane :
Quote:
Print Report Test Fatal error: Call to undefined method com::CreateObject() in D:\xampp\htdocs\coba\cr.php on line 9
ini full script ane:
Quote:
<?php
//- Variables - for your RPT and PDF
echo "Print Report Test";
$my_report = "D:\\xampp\\htdocs\\cia\\cr\\komen.rpt"; //rpt source file
$my_pdf = "D:\\xampp\\htdocs\\cia\\cr\\komen.pdf"; // RPT export to pdf file //-Create new COM object-depends on your Crystal Report version
$ObjectFactory= new COM("CrystalRuntime.Application.8.5") or die ("Error on load"); // call COM port
$crapp = $ObjectFactory->CreateObject("CrystalDesignRunTime.Application"); // create an instance for Crystal
$creport = $crapp->OpenReport($my_report, 1); // call rpt report
// to refresh data before
//- Set database logon info - must have
$creport->Database->Tables(1)->SetLogOnInfo("localhost", "komentar", "root", "");
//- field prompt or else report will hang - to get through
$creport->EnableParameterPrompting = 0;
//- DiscardSavedData - to refresh then read records
$creport->DiscardSavedData;
$creport->ReadRecords();
//export to PDF process
$creport->ExportOptions->DiskFileName=$my_pdf; //export to pdf
$creport->ExportOptions->PDFExportAllPages=true;
$creport->ExportOptions->DestinationType=1; // export to file
$creport->ExportOptions->FormatType=31; // PDF type
$creport->Export(false);
ada solusi buat masalah ane ini gan, sebelumnya ane ucapin makasih buat yang mau ngasih masukkan buat ane gan..
seenggaknya kalo agan sista gak bisa ngejelasin secara rinci, boleh lah ane dikasih link situs atawa blog yang bisa buat ngebantu ane
[SOLVED] UPDATE GAN !
Spoiler for KOREKSI:
Dengan menghilangkan variable $crapp dan menghilangkan $CreateObject pada variable $creport dan menggantinya dengan $ObjectFactory dan satu lagi nameserver yang tadinya localhost ternyata adalah nama yang telah dibuat pada DNS ODBC
Ini script yang udah bener
Quote:
<?php
//- Variables - for your RPT and PDF
echo "Print Report Test";
$my_report = "D:\\xampp\\htdocs\\cia\\cr\\komen.rpt"; //rpt source file
$my_pdf = "D:\\xampp\\htdocs\\cia\\cr\\komen.pdf"; // RPT export to pdf file //-Create new COM object-depends on your Crystal Report version
$ObjectFactory= new COM("CrystalRuntime.Application.8.5") or die ("Error on load"); // call COM port //$crapp = $ObjectFactory->CreateObject("CrystalDesignRunTime.Application");// create an instance for Crystal
$creport = $ObjectFactory->OpenReport($my_report, 1); // call rpt report
// to refresh data before
//- Set database logon info - must have
$creport->Database->Tables(1)->SetLogOnInfo("komentar", "komentar", "root", "");
//- field prompt or else report will hang - to get through
$creport->EnableParameterPrompting = 0;
//- DiscardSavedData - to refresh then read records
$creport->DiscardSavedData;
$creport->ReadRecords();
//export to PDF process
$creport->ExportOptions->DiskFileName=$my_pdf; //export to pdf
$creport->ExportOptions->PDFExportAllPages=true;
$creport->ExportOptions->DestinationType=1; // export to file
$creport->ExportOptions->FormatType=31; // PDF type
$creport->Export(false);