1622513 - No spreadsheets are available in database expert when choosing Excel as a datasource in Crystal Reports 2008

SAP Knowledge Base Article - Public

1622513 - No spreadsheets are available in database expert when choosing Excel as a datasource in Crystal Reports 2008

Symptom

  • When creating a Crystal Report based on an excel data source, spreadsheets are not shown along with the connection name in Access/Excel (DAO) connection.
  • Even if we use ODBC connection, spreadsheet are not shown
  • The same connection is working for other users who are on the same patch level for Crystal Reports 2008.

Environment

  • Crystal Reports 2008 SP3
  • Microsoft Office 2003
  • Windows XP SP2

Reproducing the Issue

  1. Create a blank Crystal Report.
  2. Expand Create New Connection and click on Access/Excel (DAO).
  3. Choose the Excel file and Database Type as Excel 8.0.
  4. Spreadsheets will not appear in Database Expert list.

Resolution

CAUTION

The following resolution involves editing the registry. Using the Registry Editor incorrectly can cause serious problems that may require you to reinstall the Microsoft Windows operating system. Use the Registry Editor at your own risk. For information on how to edit the registry key, view the 'Changing Keys and Values' online Help topic in the Registry Editor (Regedit.exe).
It is strongly recommended that you make a backup copy of the registry files before you edit the registry.
  1. Login to a working environment
  2. Go to start -> RUN -> Type "regedit" 
  3. Within Registry Key Editor go to HKEY_CURRENT_USER\Software\Business Objects\Suite 12.0\Crystal Reports 
  4. Right Click on the "Crystal Reports" folder and select "Export" OR you can choose the same option from menu File-> Export
  5. Export/Save the registry key to a folder or network, where you can access it when you login as yourself on your laptop
  6. Logout and Login as yourself on your laptop
  7. Do Steps 2 to 5, just to backup your registry keys
  8. Once the backup is done, delete "Crystal Reports" folder 
  9. Using Menu File -> Import, import the registry key that was saved earlier in Step 5
  10. Once done, reboot your computer and login to your computer again and test the connectivity

Keywords

Excel spreadsheets not available, Crystal Reports  , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V1