Crystal Reports Active X Problem

[Darren Harvey]

Hi All

 

We have been successfully using the Crystal Reports ActiveX Designer Run Time Library 10.0 to export reports to PDF in a standard OpenRoad image situation.  We are now attempting to use the same code in an Application Server compiled Image, but it is failing on the the following line in the server image.

 

  oreport.Export(false);

 

There are no error messages in the App Server log file, however debug trace messages just prior to and just after this line indicate the system is exiting the method when attempting to execute this statement.  A pdf file of size 0k is created, but when you attempt to open the file with Adobe, it indicates the file is corrupt.

 

A sample of the code is as follows:

 

Declare....

    oapplication      = extc_craxdrt!Application;
    oreport          = extc_craxdrt!Report;

    .....

 

    oreport = oapplication.OpenReport(LvRptNameWithFullpath ,0);

    oreport.EnableParameterPrompting = False;

    oreport.ExportOptions.DiskFileName      = Lv_FileName;
    oreport.ExportOptions.DestinationType   = 1;
    oreport.ExportOptions.FormatType        = 31;
    oreport.ExportOptions.PDFExportAllPages = TRUE;
 

    oreport.Export(false);

    ....

    ....

 

 

I'm hoping someone can point me to a solution for this

 

Thanks

 

Darren

Regards,

Darren Harvey

 

 

MyWorkplace Solutions Pty Limited

Level 5, 11 Queens Road

Melbourne Victoria 3004

 

Ph.   1300 733 731

Mob. 0400 398 188

Making Service our Priority

 

www.MyWorkplace.com.au

 

If you receive this email by mistake, please notify us and do not make any use of the email. We do not waive any privilege, confidentiality or copyright associated with it.

 

[Bodo Bergmann]

Hi Darren,

 

Is the environment the OpenROAD Server is running with the same as the the environment in your client image situation?

That is: Are OS level, environment variable settings, registry entries, libraries, user etc. identical?

 

Have you run both “standard image” and “OR Server” on the same machine?

 

Often it’s just a missing library or its registration (using regsvr32).

This has not to be the one directly referenced by your OpenROAD app as External Class Library,

but could also be one of its dependent libraries.

 

Bodo.

 

Bodo Bergmann | Sr. Software Engineer | Bodo.B...@ingres.com | Ingres Germany GmbH | Ohmstr. 12 | 63225 Langen | GERMANY | +49 6103 9881 0

[Darren Harvey]

Bodo

 

It is the same PC being used in both scenarios. So there should be no differences in any environment structure.

 

Darren

 

Regards,

Darren Harvey

 

 

MyWorkplace Solutions Pty Limited

Level 5, 11 Queens Road

Melbourne Victoria 3004

 

Ph.   1300 733 731

Mob. 0400 398 188

Making Service our Priority

 

www.MyWorkplace.com.au

 

If you receive this email by mistake, please notify us and do not make any use of the email. We do not waive any privilege, confidentiality or copyright associated with it.

 

---

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Bodo Bergmann
Sent: Tuesday, 8 September 2009 16:59
To: openroa...@googlegroups.com
Subject: [openroad-users] Re: Crystal Reports Active X Problem

[Bodo Bergmann]

Darren,

 

There could still be differences in the environment settings.

Remember the server image will be started from orspo which starts an oraso .

The orspo is started from the “OpenROAD Service”, so the DCOM settings, e.g. the “Identity” for the “OpenROAD SPO Server Pooler”,

determine the user under which it is running.

Running with a different user might therefore cause all kind of problems (starting with file permissions).

In addition, some environment variables might not be set for the servers,

e.g. if they are not set as System environment variables in the control panel,

but only for a user or in a login batch script.

 

Bodo.

<BR

[Durwin Wright]

The ORASO by default will inherit the account information that was used to launch the ORSPO.  Has the application been run from an OpenROAD instance under the same account as the ORASO?

 

Durwin Wright | Sr. Architect | Durwin...@ingres.com | Ingres | 500 Arguello Street | Suite 200 | Redwood City | CA | 94063 | USA  +1 650-587-5523 | fax: +1 650-587-5550 | “Wag the Dog”

<BR

[Gary Hansford]

Hi Darren,

 

    We use a VB wrapper to provide access to the XI reporting and preview (also to enable us to trap the XI errors and avoid losing OpenRoad).

 

   One parameter I can’t see is “Report.DisplayProgressDialog” (is it FALSE) ??

 

   And are you sure the app server can write to the filename/path that you’ve asked for ??

 

   Gary

 

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Darren Harvey
Sent: 08 September 2009 03:05
To: openroa...@googlegroups.com
Subject: [openroad-users] Crystal Reports Active X Problem

 

Hi All

E-Mail Notice and disclaimer.

This e-mail (including any attachment) is intended for the addressee named above only. As it may contain confidential or privileged information you are not allowed to copy, forward, disclose or use any part of the message or its attachments if it is not STRICTLY required by your job purpose.

If you are not the addressee named you may not copy, forward, disclose or use any part of the message or its attachments. If you received this message by mistake, please notify the sender immediately returning the e-mail and deleting it from your system. Internet communications cannot be guaranteed as secured or error-free as information could be intercepted, corrupted, lost, late or contain viruses. The sender therefore does not accept liability for any errors or omissions in the context of this message which arise as a result of Internet transmission. Please note that any opinion or view expressed in this e-mail maybe those of the author and do not necessarily reflect the opinion or view of this organization. In no case, an e-mail containing in the address words as stage, consultants or contractors may be considered as sent by a staff member of Indesit Company SpA (and its subsidiaries).Indesit Company UK Limited
Registered Office: Morley Way, Peterborough, PE2 9JB.
Company Number 106725. EEE Reg. Number WEE/DH0057TS

[Darren Harvey]

All

 

I added in the use of the 'DisplayProgressDialog' parameter, but it did not make a difference.

The App Server can write to the directory as the 'export' statement is creating a 0k corrupt PDF file in the specified directory.

The rest of the application is working successfully, it is only the Reports that is failing. So this would seem to indicate that the DCOM and other settings are all correct.

 

Darren

 

 

Regards,

Darren Harvey

 

 

MyWorkplace Solutions Pty Limited

Level 5, 11 Queens Road

Melbourne Victoria 3004

 

Ph.   1300 733 731

Mob. 0400 398 188

Making Service our Priority

 

www.MyWorkplace.com.au

 

If you receive this email by mistake, please notify us and do not make any use of the email. We do not waive any privilege, confidentiality or copyright associated with it.

 

---

From: openroa...@googlegroups.com [mailto:openroa...@googlegroups.com] On Behalf Of Gary Hansford
Sent: Tuesday, 8 September 2009 19:56
To: openroa...@googlegroups.com
Subject: [openroad-users] Re: Crystal Reports Active X Problem

[Eric Whitchurch]

Darren,

 

When I do this in .NET (I am not an OpenROAD programmer), I call  the Export method with a pointer to the options setup before the call.

.

.

.

Private _oExportOptions As New CrystalDecisions.Shared.ExportOptions

......

..Code to set _oExportOptions properties

.....

.

.

.

Try

_CRReportDoc.Export(_oExportOptions)

Catch ex as CrystalDecisions.CrystalReports.Engine.ExportException

.....

...

End Try

 

I notice you call the equivalent <objectname>.Export(false)

 

Is this something different with OpenROAD?

 

 

 

Eric Whitchurch

 

 

MyWorkplace Solutions Pty Limited
Level 5, 11 Queens Road
Melbourne Victoria 3004

 

Ph.   1300 733 731
Mob. 0408 172 789
Fax.  03 9710 1112
Making Service our Priority

 

www.MyWorkplace.com.au

 

If you receive this email by mistake, please notify us and do not make any use of the email. We do not waive any privilege, confidentiality or copyright associated with it.

<BR

[Bodo Bergmann]

Darren,

 

have you actively checked the DCOM settings, i.e. the “Identity” – or do you just assume that the settings are correct as everything else is working?

As mentioned in my other email there could still be different environment variable settings, etc. when running from a desktop client than when running via the OR Server.

How do you start your desktop client image?

Using “w4glrun …” or via a batch script?

Do you have the same flags for the registered server app as for w4glrun?

If started via batch script – what other settings are made therein?

Are there any scripts running at login time?

Is there anything started for Crystal Reports using the “Startup” start menu group?

 

Are there any logon information required when running the report?

Are they set when running via the OR Server?

 

This seems to be a similar problems:

http://www.experts-exchange.com/Programming/Languages/C_Sharp/Q_22823286.html

but I don’t have an account on experts-exchange, so I can’t see the solutions.

Also look here:

http://codebetter.com/blogs/peter.van.ooijen/archive/2004/02/11/Exporting-from-Crystal-Reports-to-PDF_2C00_-Word_2C00_-Excel-and-HTML.aspx

Quote:

” When Crystals creates a report is does create a temporary .rpt file. This file is stored in the windows\temp dir, it's name is a guid. When Crystal creates the exported report it creates a directory in the root directory supplied with the name of this guid. In this directory the report will be created, using the filename supplied”

So are the Windows\Temp and the root directory writeable for the owner of the oraso process?

Also look for the entry from Mani (on 04-19-2007 5:51 PM), which describes similar symptoms.

 

Bodo.

<BR