note 87846 added to class.com

From: Date: Fri, 26 Dec 2008 09:05:49 +0000
Subject: note 87846 added to class.com
Groups: php.notes 
Request: Send a blank email to php-notes+get-148515@lists.php.net to get a copy of this message
Hi, just wanna share to everyone after tried and tested many many times to create report in PDF format from Crystal Report. Finally I can do it without any error. Here is my system; PHP 5.1.6, MSSQL2005 and Crystal Report Server XI RL2 <?php //- Variables - for your RPT and PDF echo "Print Report Test"; $my_report = "D:\\Folder1\\SubFolder1\\Report.rpt"; // rpt source file $my_pdf = "D:\\Folder1\\SubFolder1\\Report.pdf"; // RPT export to pdf file //-Create new COM object-depends on your Crystal Report version $ObjectFactory= new COM("CrystalReports115.ObjectFactory.1") 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("servername", "DBname", "user", "password"); //- 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); //------ Release the variables ------ $creport = null; $crapp = null; $ObjectFactory = null; //------ Embed the report in the webpage ------ print "<embed src=\"D:\\Folder1\\SubFolder1\\Report.pdf\" width=\"100%\" height=\"100%\">" ?> That's all for me, anyway in Crystal Report I have to check DisCardSavedData, Save data with report and AutoSave (1 min) in Option Tab and also in Report Options I have to check save dat with report, too. Hope this should be help to anybody Casanoteva ---- Server IP: 92.48.74.199 Probable Submitter: 203.121.133.47 (proxied: 203.121.176.4) ---- Manual Page -- http://www.php.net/manual/en/class.com.php Edit -- https://master.php.net/note/edit/87846 Del: integrated -- https://master.php.net/note/delete/87846/integrated Del: useless -- https://master.php.net/note/delete/87846/useless Del: bad code -- https://master.php.net/note/delete/87846/bad+code Del: spam -- https://master.php.net/note/delete/87846/spam Del: non-english -- https://master.php.net/note/delete/87846/non-english Del: in docs -- https://master.php.net/note/delete/87846/in+docs Del: other reasons-- https://master.php.net/note/delete/87846 Reject -- https://master.php.net/note/reject/87846 Search -- https://master.php.net/manage/user-notes.php

« previous php.notes (#148515) next »