Export to Excel 2007 failed - Invalid export DLL or export format.

[Former Member]

Hi,

Environment:

OS: Windows XP (SP3)

Crystal Reports : 12.1.0.892

We have a problem for exporting few reports to Excel 2007 (Export to Excel 2003 works fine for those reports).

Getting the bellow while trying to Export to Excel 2007.

-

---

Crystal Report Windows Forms Viewer

-

---

Error in File CDSFUN01 {99B42BC5-2FBB-4F75-A4F5-D7B5B7B6AE0B}.rpt:

Invalid export DLL or export format.

-

---

OK

-

---

-

---

Export Report

-

---

Export failed.

-

---

OK

-

---

Its the same case even if we try to Export blank report to Excel 2007 as well. Please help.

[Former Member · Accepted solution]

Refer to this thread that discuss about the same issue:

Actually Exporting report to Microsoft Excel 2007 in .xlsx format is not available in Crystal Reports 2008. However you can export the report to xls format which is compatible and can be opened with Microsoft Excel 2007.

Thanks

[Former Member · Accepted solution]

Thanks for the reply.

We are exporting to Microsoft Excel (97-2003) only (not to xlsx).

And more over we can able to export our reports to Excel (97-2003) (Ver of Excel: 12.0.6425.1000).

But export fails on Systems having ver of Excel: 12.0.6529.5000

Please help.

[saurabh_pathak · Accepted solution]

I will make sure that I am on the latest patch ie SP4

https://smpdl.sap-ag.de/~sapidp/012002523100008782452011E/cr2008sp4.exe

You can find the rumtimes here:

MSI:

https://smpdl.sap-ag.de/~sapidp/012002523100008782532011E/cr2008sp4_redist.zip

MSM:

https://smpdl.sap-ag.de/~sapidp/012002523100008782522011E/cr2008sp4_mm.zip

ClickOnce

https://smpdl.sap-ag.de/~sapidp/012002523100008782442011E/cr2008sp4_clickonce.zip

Recompile the app and then deploy.

What is the .NET Framework used by the application?

Method of deployment?

OS where app is deployed, x86 or x64?

Are you able to export the report from designer ie CR2008 Standalone?

- Saurabh

[Former Member · Accepted solution]

Thanks for quick reposnse.

What is the .NET Framework used by the application?

>> 1.1 framework

Method of deployment?

>> We have build MSI out of MSM for SP3 and installed MSI on user PCs

OS where app is deployed, x86 or x64?

>> Currently having x86 only.

Are you able to export the report from designer ie CR2008 Standalone?

>> Yes with Ver of Excel: 12.0.6425.1000. But fails with ver of Excel: 12.0.6529.5000

[Former Member · Accepted solution]

Do you still have the same error if you are using .NET FRamework 2.0?

[Former Member · Accepted solution]

Is it possible to have the exact version of your product including SP and FP applied.

If you are using the runtimes of SP3 I will recommand you to use the ones of FP 3.1 and see how it goes.

[Former Member · Accepted solution]

I believe Crystal Reports : 12.1.0.892 is of SP3.

Please help from where I can download FP 3.1

[Former Member · Accepted solution]

Refer to this Link[SAPNOTE 1467600 - Error: "Invalid export DLL or export format" when exporting to XLS format and connecting to Oracle in a VS .NET application|https://bosap-support.wdf.sap.corp/sap(bD1lbiZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3134363736303026]

Crystal Reports 2008 + SP3 should be of version of type 12.3.x.xxx

Thanks

[Former Member · Accepted solution]

I have tried browsing to the specified link, but getting Network Error (tcp_error).

Tried 4 to 5 times giving 30 mins gap in between, but no luck

A communication error occurred: ""

The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.

For assistance, contact your network support team.

[Former Member · Accepted solution]

You can try this Link: [https://service.sap.com/sap/support/notes/1467600] or search for the SAPnote from the service market place. The SAPNOTE is: 1467600