|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
[2006-05-23 16:42 UTC] mitohuffman at yahoo dot com dot mx
Description:
------------
I made a script that open a Crystal Reports file and export it to PDF. I set the database info, the RecordSelectionFormula string and de ExportOptions and all works fine. The problem comes when i try to call the ParameterFieldDefinitions class.
GBY
Reproduce code:
---------------
$ObjectFactory= New COM("CrystalReports10.ObjectFactory.1");
$crapp = $ObjectFactory->CreateObject("CrystalDesignRunTime.Application");
$creport = $crapp->OpenReport($report, 1);
$creport->Database->Tables->Item(1)->ConnectionProperties['User ID'] = "MyUser";
$creport->Database->Tables->Item(1)->ConnectionProperties['Password'] = "MyPass";
$creport->FormulaSyntax = 0;
$creport->RecordSelectionFormula = "{V_CON_LOTES.ID_CONCURSO}=$id_concurso and {LOTES_CONCURSO_COTIZADOS.ID_ESTATUS}=1";
$param1 = $creport->ParameterFieldDefinitions->Item("fecha_imp"); // Error Point. I tried using Item(1) and i get the same error.
Expected result:
----------------
Get the "Fecha_imp" parameter, set (before) in the Crystal Reports Designer, for setting the corresponding value.
Actual result:
--------------
Fatal error: Uncaught exception 'com_exception' with message 'Unable to lookup `ParameterFieldDefinitions': Nombre desconocido. ' in C:\Inetpub\wwwroot\Crystal_reports\test.php:19 Stack trace: #0 C:\Inetpub\wwwroot\Crystal_reports\test.php(19): unknown() #1 {main} thrown in C:\Inetpub\wwwroot\Crystal_reports\test.php on line 19
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sat Nov 01 14:00:01 2025 UTC |
Happened the same to me but then I tried changing one line like in an example on the infamous Crystal Report's Developers Help: $crapp = $ObjectFactory->CreateObject("CrystalDesignRunTime.Application"); to: $crapp = $ObjectFactory->CreateObject("CrystalRunTime.Application"); Notice the lack of the word 'Design'. All of a sudden it started to work. Why it happens? I don't know but it worked for me. Give it a try.