Hi everybody,

I have a BIG problem with Crystal Reports 9. I try to print a report from a PHP page and it doesn't seem to work. Could anyone give me a hint why it's not working ? (Code following)

$crapp = new COM("CrystalRuntime.Application.9");
$creport = $crapp->OpenReport("C:\\Foxserv\\www\\Etat1.rpt", 1);

$creport->DiscardSavedData();
$creport->ReadRecords();

echo 'Driver Name : ' . $creport->DriverName.' **<br>';
echo 'Printer Name : ' . $creport->PrinterName.' **<br>';
echo 'Port Name : ' . $creport->PortName.' **<br>';

$creport->SelectPrinter("HP LaserJet 1100(MS)", "HPLocal", "LPT1:");
$creport->PaperOrientation = 0;

$creport->PrintOut(False);
echo 'creport->PrintingStatus->Progress : ' . $creport->PrintingStatus->Progress . '<br>';

All this displays :

Driver Name : DISPLAY **
Printer Name : **
Port Name : **
creport->PrintingStatus->Progress : 3

I can't figure why the driver name is DISPLAY and it's killin' me

Thanx for all ideeas.

I wish I could help you. I tried searching on Google and couldn't find the Crystal Reports COM API documented. Crystal Reports is commercial software, perhaps as a licensed user you can call them or look through their support pages for the documentation.

Also, whenever dealing with objects or complex variables in PHP, it helps to make use of the var_dump() and/or print_r() functions.
  http://www.php.net/var_dump
  http://www.php.net/print_r

They may shed some light on your object by displaying the internal variable structure.

Don't forget to wrap the output in <pre></pre> tags so it's readable.


Take care,

Nik
http://www.bigaction.org/

I need to generate crystal reports. I am using PHP & MySQL on Linux Platform. is it possible to generate crystal reports?? the internet is not helping me. If u can tell me what extra tools are to be installed and also give me a tinzy winzy example I will be able to continue.

divya

Hello Divya...
can you please send me some links or code regarding your problem...i too using Crystal reports XI...kindly send me or tell me abt "How to generate Crystal reports with PHP". i think we need to use some Third party tool for this..thanx in advance.
Raman

Raman Kheterpal
Web Programmer
Centre for IT Applications (CITA)
T E R I, India Habitat Centre,
Lodhi Road, New Delhi- 110003

please i want know how, to generate Crystal reports with PHP.

Crystal Reports is a Windows only app

PHP COM function can interact with CR


I wish my computer would do what I want it to do, not what I tell it to do

did someone solve this problem?, Me too, I need to generate a Crystal reports format report with data from MySQL database and using PHP. all the anwsers I got are create a COM object and open a .rtp file, do something;

- My question is where can I get a .rtp file, is this file the final result for me?
- If this is the resulted file, someone will download and display with their Crystal Report software, then what I need is the export my data from database( as I did for CSV file) to .rtp file. is there a file in PHP to do that, or Crystal Report COM object has this functionality;


I really need your urgent help;


Thank you in advance


JZ

hi there,
please provide me some code sample of showing crystal report in php.

Mamun
[email protected]

Hi All,

I m tring to integrate the Crystal report wiht PHP

$COM_Object = "CrystalReports12.ObjectFactory.1";
$my_report = "C:\\Report1.rpt";
$ObjectFactory= New COM($COM_Object);
$creport = $ObjectFactory->OpenReport("c://report1.rpt", 1);

It gieves following error
>>>>>>>>>>>>>>>

Call to undefined method com::OpenReport()
please advice
santosh

santosh