Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //- Variables - for your RPT and PDF
- //echo "Print Report Test";
- $my_report = "D:\\Program Fiels\\xampp\\htdocs\\RPT\\RPT-list.rpt"; //
- //rpt source file
- $my_pdf = "D:\\Program Fiels\\xampp\\htdocs\\RPT\\RPT-list.pdf"; // RPT export to pdf file
- //-Create new COM object-depends on your Crystal Report version
- $ObjectFactory= new COM("CrystalReports10.ObjectFactory.1") or die ("Error on load"); // call COM port
- $crapp = $ObjectFactory-> CreateObject("CrystalRuntime.Application.10"); // 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", "username", "password", "databasename");
- //- 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;
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement