Invalid export DLL or export format" with Crystal Reports 2008 to Excel xls

[Former Member]

We are experiencing the same issue as reported in the sticky thread. I answered in that thread, but thought that I woudl open a new thread to keep track of this issue. I can give you the responses to your questions you have requested in that thread:

Server Operating System - MS Windows Server 2003 R2 Enterprise Edition SP2

Version of the .NET Framework - MS .NET Framework 3.5 SP1

How did you deploy? - Installed CR 2008 SP1 runtime with msi package

If you deployed with CRRuntime_12_0_mlb.msi - what was the date of the file and its size? CRRuntime_12_1_mlb.msi dated Sept. 16, 2008 12:55:00 PM, size: 56,717,824 bytes

What is the file version of crpe32.dll on your server? You'll find this in the C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86 directory - File was created 9/13/08 11:21AM, 9451KB File Version: 12.1.0.882

How many libpng10.dll files are on your system? List all instances. - 1 instance is on the system located in C;\Program Files\Business Objects\Business Objects Enterprise 12.0\win32_x86 directory. It is dated 9/13/08 8:52:26AM 132KB version 1.0.30.1

Any additional comments - We have tried to export to PDF and this works successfully. However, we can not export to xls or rft formats.

CRXF_XLS.dll is 905KB 9/13/08 9:38AM Version 12.1.0.882

CRXF_RTF.dll is 509KB 9/13/08 9:35AM Version 12.1.0.882

We also have the CR XIR2 server runtime installed side by side on the server as we migrate from CR 2008 to CR XIR2 SP4 ( where this function does work currently).

Please let me know if you need anything additional.

Phil

"Invalid export DLL or export format" with Crystal Reports 2008

Posted: Sep 27, 2008 12:36 AM E-mail this message Reply

I've included this sticky because we are seeing many posts in this forum regarding the error Invalid export DLL or export format when exporting to Excel and RTF in .NET applications using the Crystal Reports 2008 .NET SDK.

Issue

Exporting a Crystal Report to Excel or RTF format

.NET application using the Crystal Reports 2008 runtime (version 12.0)

error Invalid export DLL or export format

We've been doing some testing in-house and haven't reproduced this behavior. In order to figure this issue out we will need your help. If you are getting this error please reply to this post with the following information:

Server Operating System

Version of the .NET Framework

How did you deploy?

If you deployed with CRRuntime_12_0_mlb.msi - what was the date of the file and its size?

What is the file version of crpe32.dll on your server? You'll find this in the C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86 directory

How many libpng10.dll files are on your system? List all instances.

Any additional comments

What We Know

The error invalid export DLL or export format may occur when exporting to Excel and RTF formats in .NET applications utilizing the Crystal Reports 2008 runtime (v 12.0)

Other export formats like Adobe PDF, Crystal Reports, CSV all export with no error

Some customers have resolved this by adding C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86 to their environment path variables

This may have something to do with the file libpng10.dll. Both crxf_xls.dll and crxf_rtf.dll are dependent on it.

Thanks in advance for your co-operation. We hope to figure out what is causing this issue soon.

[former_member183750 · Accepted solution]

Philip, does the suggestion of setting the environment path variables C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86 work for you? Not sure if that is a viable workaround for you. Also, the solution did work for most cases I am aware of, but there are others that report the issue was not resolved.

Also, please confirm that this solution does work on your development system, but exhibits the error once deployed to the WIN 2003 server(?).

Finally, would you be willing to work on this with me over email? I'd essentially need you to run a few utilities on the server, get me the logs and I'd want to go through these to see what gives...

Ludek

[Former Member · Accepted solution]

Ludek,

I've tried both the environement variable and modifying my registry entry. Neither worked.

The export does not work on a machine that just has the crystal reports runtime installed. On a local desktop that has the entire crystal 2008 development kit installed, the report exports fine in excel.

I'd be more than willing to run whatever you need me to run on my machine. How do we get started?

[former_member183750 · Accepted solution]

Excellent. I'll contact you via email off line as I will need you to send me logs from a couple of utilities and the forum does not allow for attachments.

Ludek

[former_member183750 · Accepted solution]

Philip, I'm getting a bit of resistance on working this issue with you over email. However I have been told that you belong to a government organization (I was told you have State.US.gov address)(?). If so, you may have a support contract. Most gov agencies do. Would you be able to create a support case here:

https://websmp101.sap-ag.de/message

Ludek

[Former Member]

Hi Phil

Did you fix this issue? Could you please share the way you fixed it please?

I met the same issue, and i tried many ways posted in forum but haven't no results.

[Former Member]

Hi,

I am also having the same problem, except that I am not using Crystal Report 2008 runtime but the actual Crystal Report 2008 installation on Windows XP SP2 with VS Studio 2005 (VC++). MS .NET Framework 2.0.

Cyrstal Report XIR2 was installed on the same machine but uninstalled before installing Crystal Report 2008.

So only one instance of libpng10.dll and found in C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86

Crpe32.dll 3/1/2008 version 12.0.0.683

Crxf_xls.dll 3/1/2008 version 12.0.0.683

Crxf_rtf.dll 3/1/2008 version 12.0.0.683

crdb_oracle.dll 3/1/2008 version 12.0.0.683

libpng10.dll 3/1/2008 version 1.0.30.0 122880 bytes

There is no problem for exporting to pdf, html, word, csv, Crystal Report. If I create a testing report without any data from database, the testing report can then be exported also to rtf and xls.

Oracle 11.1.0.6 is the DB for the reports.

Adding C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86 to the path did not resolve my problem.

Any idea to fix this issue?

Thanks

Kin H Chan

[former_member183750]

I need a bit of a clarification on this info:

"I am also having the same problem, except that I am not using Crystal Report 2008 runtime but the actual Crystal Report 2008 installation on Windows XP SP2 with VS Studio 2005 (VC++). MS .NET Framework 2.0."

Are you working with CR 2008, creating an application using VS 2005?

How does VC++ come into the picture? There is no SDK in CR 2008 that would support C++(?).

What CR references are you using in your .NET project / app?

Ludek

[Former Member]

Hi Ludek,

Sorry for the confusion. Our application is written in VS C++ and our application prints reports created from CR 2008. So in our codes, we access the reports using the CR 2008 .NET SDK.

By reading the other threads, I found that when I dropped libpng10.dll to the same folder where my executable is located, export to xls will be fine. I am kind of wondering why adding C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86 to my path did not solve my problem.

I guess I should create another thread rather than piggy back on this one.

Thanks

Kin H Chan

[Former Member]

Sorry for creating another thread - just want to post the solution here.

Because I was using VS C++ env for testing, using the path:

C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86

was not good. Instead I need to use the short form:

c:\progra_1\busine1\busine~1.0\win32_x86

Thanks

Kin H Chan

[Former Member]

Hi Kim!

Did you fixed this bug? Could you please share your experiences resolving the issue please?

[former_member183750]

Since this thread was closed in 2008, I'd sugest creating a new thread and adding some more details.

Please see the [Rules of Engagement|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement]

Step 2 Asking Your Question; Provide Enough Information

Ludek

Follow us on Twitter http://twitter.com/SAPCRNetSup

Got Enhancement ideas? Try the [SAP Idea Place|https://ideas.sap.com/community/products_and_solutions/crystalreports]