note 87846 deleted from class.com by thiago

Note Submitter: casanoteva at yahoo dot com ---- 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