SAP Knowledge Base Article - Public

1603398 - How to trace data source connections in Crystal Reports and in .NET SDK's application 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.  It will then start tracing.
              
    3. Once you finish reproducing the issue, the log file will be located in the directory defined in the Environment Variable: LOGGING_DIR, which is: c:\logging, in the example provided.
            
         
      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