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
- In Crystal Reports, create a report based on a relational data source?
- Add a couple of database fields to the report.
- Add a Record Selection formula.
- 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"
- In Crystal Reports, open the report.
- Refresh the report.
- Wait for the report to display the first page.
- Under the menu "Report", select "Performance Information..."
- In the window "Performance Information", in the left pane, select "Performance Timing"
- 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.
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