2572686 - How to distribute the Database Expert Options set in Crystal Reports to multiple users?

SAP Knowledge Base Article - Public

2572686 - How to distribute the Database Expert Options set in Crystal Reports to multiple users?

Symptom

  • How to distribute Database Expert Settings to multiple users?
  • Are there registry keys where the Database Expert Options set in Crystal Reports are stored?

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016

Reproducing the Issue

  1. Start Crystal Reports designer.
     
  2. Create a new report and create a connection to any data source in the Database Expert.
     
  3. Notice that by default the Stored Procedures are not visible.
     
  4. Set the Database Options to display stored procedure, by selecting under the menu "File - Options"
    Then in the Options windows, under the  tab "Database", check the option Stored Procedure.
  5. Now when creating a new report in Crystal Reports, and connecting to any data sources, it shows Stored procedures.
     
    How to distribute the same Database Options set in Crystal Reports to multiple Users?

Resolution

  • WARNING The following resolution involves updating the Microsoft Registry. Using the Microsoft Registry Editor incorrectly can cause serious problems. Use the Microsoft Registry Editor at your own risk. For more information see the SAP Knowledge Base Article 1323322
      
  • Crystal Reports stores the Database Options selected in the following registry key:
      
    • HKEY_CURRENT_USER\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions
      • IncludeStoredProcedure
      • IncludeSynonym
      • IncludeBaseTable
      • IncludeSystemTable
          
  • Therefore to distribute the Database Options selected to other user, open the Microsoft Registry Editor, and export the keys to a .reg file:
          
          HKEY_CURRENT_USER\SOFTWARE\SAP BusinessObjects\Suite XI 4.0\Crystal Reports\FetchOptions key 
              
    Then distribute the file to other users. Other users then need to execute the file to populate the registry with the same values.

Keywords

SPs , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016