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 2008
- SAP Crystal Reports 2011
- 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:
- Download the crlogger utility:
-
For Crystal Reports 2011, 2013, 2016 and 2020, the crlogger.dll file is already installed by default, therefore, go to step 2 directly.
- For Crystal Reports 2008, you will first need to download the crlogger dll, and copy it in the right folder:
- Download the utility crlogger.dll, available in the Attachments section below. ( crlogger.dll.12.zip )
- Extract the file crlogger.dll to the following location depending on if you are using a 64bit or 32bit version of MS Windows:
For 64bit: C:\Program Files (x86)\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
For 32bit: C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\win32_x86
- 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.
- Open Crystal Reports or your .NET application, and run the report and it will then start tracing.
- Once you finish reproducing the issue, the log file will be located in the directory you 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
Crystal Reports 2008, CR for VS, database logging, crlogger trace tracing 2011 CR2011 CR2008 designer , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To
Product
Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020
Attachments
crlogger.dll.12.zip |