PROBLEM:
This error message "Invalid Export DLL or Export Format" exporting to Excel XLS is generally triggered by Crystal Reports templates connecting to Oracle via the Oracle ODBC driver (instead of Microsoft Oracle ODBC driver). There is an issue with the DLL "LIBPNG10.DLL".
POSSIBLE SOLUTIONS:
- Use Microsoft ODBC Driver for Oracle
- Add C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86 to the environment path variables
- Back up the libpng10.dll in C:\oracle\product\11.1.0\db_1\bin and replace it with the libpng10.dll from c:\program files\business objects\businessobjects enterprise 12.0\win32_x86
- Ensure that the reg key HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\Path has a path value of
C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
---
Note, if you're needing to make these updates for our Report Runner software, the locations of registry and file paths are different:
- Use Microsoft ODBC Driver for Oracle
- Add C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86 to the environment path variables
- Back up the libpng10.dll in C:\oracle\product\11.1.0\db_1\bin and replace it with the libpng10.dll from c:\program files\business objects\businessobjects enterprise 12.0\win32_x86
- Ensure that the reg key HKLM\SOFTWARE\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Crystal Reports\Path has a path value of
C:\Program Files (x86)\SAP BusinessObjects\Crystal Reports for .NET Framework 4.0\Common\SAP BusinessObjects Enterprise XI 4.0\win32_x86
---
Supporting SAP documentation on this issue can be found here:
http://forums.sdn.sap.com/thread.jspa?threadID=1065075&start=0&tstart=0