note 87846 added to class.com
| From: | casanoteva at yahoo dot com | 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