1216415 - How to change the isolation level for an ODBC connection in Crystal Reports?

SAP Knowledge Base Article - Public

1216415 - How to change the isolation level for an ODBC connection in Crystal Reports?

Symptom

  • How to ser a different database isolation level?
  • How to change the isolation level Crystal Reports uses when connecting via ODBC to data sources?

Environment

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

Cause

  • When connecting via ODBC to a database, Crystal Reports uses the highest database isolation level the database driver supports, which is Read Committed.

Resolution

  • To change the default isolation level used when connecting to a data source via ODBC in Crystal Reports, follow the steps outlined below:
       
    1. Add the appropriate registry keys depending of the product version used
  • Crystal Reports 9 and Crystal Enterprise 9

HKEY_LOCAL_MACHINE\Software\Crystal Decisions\9.0\Crystal Reports\Database\ODBC

  • Crystal Reports 10 and Crystal Enterprise 10

HKEY_LOCAL_MACHINE\Software\Crystal Decisions\10\Crystal Reports\Database\ODBC

  • Crystal Reports XI Release 1 and BusinessObjects XI Release 1

HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11\Crystal Reports\Database\ODBC

  • Crystal Reports XI Release 2 and BusinessObjects XI Release 2

HKEY_LOCAL_MACHINE\Software\Business Objects\Suite 11\Crystal Reports\Database\ODBC

  • Crystal Reports for Visual Studio .Net 2002, 2003 

HKEY_LOCAL_MACHINE\Software\Crystal Decisions\9.0\Crystal Reports\Database\ODBC

  • Crystal Reports 2008

   HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Crystal Reports\Database\ODBC

  • Crystal Reports 2011

   HKEY_LOCAL_MACHINE\SOFTWARE\SAP Business Objects\Suite XI 4.0\Crystal Reports\Database\ODBC

            Note: It can also be added under HKEY_CURRENT_USER 
            Note: for 64-bit machines the HKEY_LOCAL_MACHINEregistry  keys would be at the following location:
            HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\... 

               2. Create a "DWORD value" called "IsolationLevel" 

               3. Set the value of "IsolationLevel" to the desired isolation level.  The following are the recognized values:

          1 - Read Uncommitted

          2 - Read Committed

          4 - Repeatable Read

          8 - Serializable
            

               4. Apply the latest product update if you are using one of the following product: 

          • Crystal Reports 9
          • Crystal Enterprise 9
          • Crystal Reports for Visual Studio .Net 2002
          • Crystal Reports for Visual Studio .Net 2003 

          Isolation levels in the above products remain set to "Read Commited" regarless of the setting of the registry key. This issue was tracked under ADAPT00194820 and resolved in the latest product updates.

          Product updates are available in:

          • SAP Community Network at http://sdn.sap.com under "Business Objects" - "Business Objects Downloads"  
          • Service Market Place

           For Crystal Reports for Visual Studio .Net 2002 apply the following update:
           
                http://ftp1.businessobjects.com/outgoing/EHF/crnet10win_en.zip


           For Crystal Reports for Visual Studio .Net 2002 apply the following update:
            
                http://ftp1.businessobjects.com/outgoing/EHF/crnet11win_en.zip

          Note: If a particular isolation level is requested but the ODBC driver does not support the isolation level specified,  it will use the ODBC driver default isolation level.

          Keywords

          CE CR SP READ COMMITTED DATABASE DEFAULT ISOLATION DIRTY READ Crystal Reports Database Isolation Read Committed , c2014122, ADAPT00194820 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , How To

          Product

          Crystal Reports 2008 V0 ; Crystal Reports 2008 V1 ; SAP Crystal Reports 10.0 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 9.0 ; SAP Crystal Reports XI ; SAP Crystal Reports XI R2