I am getting error on
Fatal error: Class 'registryDatabaseLocations'.
2nd problem is when I run code by commenting
>> o_CrReport->Database->LogOnServer
>> (
>> 'odbc',
>> 'Ac// Logon to the database.
>> $counts',
>> registryDatabaseLocations::Database('Accounts'),
>> registryDatabaseLocations::Username('Accounts'),
>> registryDatabaseLocations::Password('Accounts')
>> );
its shows data which is saved with report n not showing fresh data also it
fails to send parameters.
Gavin Chalkley wrote:
>
> Luhana,
>
> What is line 19?
>
> Please show the coding
>
> On 23/12/2011 01:26, luhana wrote:
>> Dear Sir
>> I am getting error
>> Fatal error: Class 'registryDatabaseLocations' not found in
>> C:\wamp\www\cc3.php on line 19
>> please guide
>>
>>
>>
>> Richard Quadling wrote:
>>> 2009/4/30 John Messam<johnmess@xxxxxxxxxxx>:
>>>> I am trying to write a php program that opens a number of reports
>>>> written
>>>> in Crystal 11. From research on the internet, I found that CR would
>>>> have
>>>> to be called using COM. So I did that. From the command line it
>>>> triggers
>>>> a dialog box saying that the version of Crystal the reports was written
>>>> in was later than the one that is being used to open it via the php
>>>> program. The other problem is that when it is run from the browser
>>>> the
>>>> program hangs on the openReport command
>>>>
>>>>
>>>>
>>>> Can anyone assist me on resolving the hanging issue or the entire thing
>>>> for that matter.
>>>>
>>>>
>>>>
>>>> Thanks!
>>>>
>>>>
>>>>
>>>> John
>>>>
>>>> _________________________________________________________________
>>>> Show them the way! Add maps and directions to your party invites.
>>>> http://www.microsoft.com/windows/windowslive/products/events.aspx
>>> I use Crystal all day and via PHP also.
>>>
>>> Here is the code I use (edited). It might not be perfect, but it works
>>> perfectly.
>>>
>>> <?php
>>> // Create an Crystal Object Factory.
>>> $o_CrObjectFactory = new COM('CrystalReports11.ObjectFactory.1');
>>>
>>> // Create the Crystal Reports Runtime Application.
>>> $o_CrApplication =
>>> $o_CrObjectFactory->CreateObject("CrystalRunTime.Application.11");
>>>
>>> // Register the typelibrary.
>>> com_load_typelib('CrystalDesignRunTime.Application');
>>>
>>> // Load the report.
>>> $o_CrReport = $o_CrApplication->OpenReport('C:\Report.rpt', 1); // 1
>>> == crOpenReportByTempCopy.
>>>
>>> o_CrReport->Database->LogOnServer
>>> (
>>> 'odbc',
>>> 'Ac// Logon to the database.
>>> $counts',
>>> registryDatabaseLocations::Database('Accounts'),
>>> registryDatabaseLocations::Username('Accounts'),
>>> registryDatabaseLocations::Password('Accounts')
>>> );
>>>
>>> // Don't tell anyone what is going on when running live.
>>> $o_CrReport->DisplayProgressDialog = False;
>>>
>>> $s_ExportedReport = 'C:\Report.pdf';
>>>
>>> // Run the report and save the PDF to disk.
>>> $o_CrReport->ExportOptions->DiskFileName = $s_ExportedReport;
>>> $o_CrReport->ExportOptions->PDFExportAllPages = True;
>>> $o_CrReport->ExportOptions->DestinationType = 1; // Export to File
>>> $o_CrReport->ExportOptions->FormatType = 31; // 31 = PDF, 36 = XLS, 14 =
>>> DOC
>>>
>>> // Assign the parameters to the report.
>>> $m_Stuff = new Variant();
>>>
>>> $o_CrPeriodsParam =
>>> $o_CrReport->ParameterFields->GetItemByName('PeriodIDs', $m_Stuff);
>>> $o_CrPeriodsParam->ClearCurrentValueAndRange();
>>>
>>> foreach($_SESSION['tabRG_PeriodIDs'] as $i_Period)
>>> {
>>> $o_CrPeriodsParam->AddCurrentValue(intval($i_Period));
>>> }
>>>
>>> $o_CrReport->ReadRecords();
>>> $o_CrReport->Export(False);
>>> ?>
>>>
>>>
>>>
>>> --
>>> -----
>>> Richard Quadling
>>> Zend Certified Engineer :
>>> http://zend.com/zce.php?c=ZEND002498&r=213474731
>>> "Standing on the shoulders of some very clever giants!"
>>>
>>> --
>>> PHP Windows Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>>>
>
>
--
View this message in context: http://old.nabble.com/PHP-and-Crystal-Reports-tp23308716p33029662.html
Sent from the Php - Windows mailing list archive at Nabble.com.
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
