Google
  Web www.spinics.net

Re: PHP and Crystal Reports

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]


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



[PHP Home]     [PHP Users]     [PHP Install]     [PHP on Windows]     [Programming PHP]     [Kernel Newbies]     [Rice Cooker]     [Home]     [Yosemite News]     [Yosemite Photos]     [PHP Books]

Powered by Linux