SAP Knowledge Base Article - Public

3224313 - How to find how long a SQL Query takes to execute on the database side, when refreshing a report in Crystal Reports?

Symptom

  • How long does a report SQL Query take to execute on the database side?
  • How to find the time it take for a SQL Query to process on the database, when refreshing a report in Crystal Reports?

Environment

  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025

Reproducing the Issue

  1. In Crystal Reports, create a report based on a relational data source?
  2. Add a couple of database fields to the report.
  3. Add a Record Selection formula.
  4. Refresh the report.
      
    How long the SQL Query sent to the database takes to execute on the database side? 

Resolution

  • To know how long it takes for the SQL Query sent to the database side takes to execute, look at the report Performance Timing value for: "Run the Database Query"
    1. In Crystal Reports, open the report.
        
    2. Refresh the report.
        
    3. Wait for the report to display the first page.
        
    4. Under the menu "Report", select "Performance Information..."
        
    5. In the window "Performance Information", in the left pane, select "Performance Timing"
         
    6. The time it took for the SQL Query to execute on the database side is available under the item:

           Run the Database Query
         
      Note: The time is in milliseconds, to know the time in minutes, divide the time it took by 60,000.

        Performance_Information.png

Keywords

CR, performance , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , How To

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025 ; SAP Crystal Reports all versions