SAP Knowledge Base Article - Public

1603398 - How to trace data source connections in Crystal Reports using crlogger? [Video]

Symptom

  • How to perform a database trace in Crystal Reports?
  • How to trace what's happening when refreshing a report in Crystal Reports?
  • How to use crlogger to generate a log when using Crystal Reports?

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
        
  • SAP Crystal Reports, developer for Visual Studio (all versions)

Resolution

  • To perform a database trace in Crystal Reports using crlogger:
                   
    1. Add the following User Environment Variables to your local system:
        
      LOGGING_DIR = C:\logging
      LOGGING_ENABLED_ASSERT = 1
      LOGGING_ENABLED_RUNTIME = 100

      NOTE:
      To enable application tracing you will need to add the above variables to the System Environment, but it may require a re-boot to take affect.
        
    2. Open Crystal Reports or your .NET application, and run the report.       
        
    3. Once you finished reproducing the issue, the log file will be located in the directory defined in the Environment Variable:   

       LOGGING_DIR      

      In the current example, the folder was set to: c:\logging      
        
  • Important Note:
    Once the trace is no longer required, disable the trace, otherwise it can impact the report performance due to the overhead of tracing each actions.
      
  • To disable generating a trace with crlogger close Crystal Report or your .NET application, perform one of the following:
    - Remove the environment variables created in step 2; or
    - To temporarily disable logging using crlogger, rename the crlogger.dll to crlogger.org or change
      • LOGGING_ENABLED_ASSERT = 0
      • LOGGING_ENABLED_RUNTIME = 0
      • Note: renaming the dll will work until a patch is installed which will re-add the crlogger.dll and start logging again.
          
           
  • Below is a video demonstrating how to setup crlogger to perform a trace in Crystal Reports.
     
        

    Media not computed.

 

Keywords

CR for VS, database logging, crlogger trace tracing , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Attachments

crlogger.dll.12.zip