How to increase the performance of a Crystal Report so it will run faster
Does it take long for your Crystal Report to complete? Sometimes, a Crystal Report can be slow because it works with such large amounts of data or because something was not created/coded properly. Try any of the following steps to speed up your Crystal Report
Other People Are Reading
Instructions
-
-
1
Before doing anything, you should run the report and take a look at it's performance using Crystal Report's built-in 'Performance Information'. The 'Performance Information' dialog box can be opened from the Report menu. It displays performance data from the last time the report was run and can show you how long each part of the report, including sub-reports, is taking to complete. It can be extremely useful when trying to determine why a report is running slow.
-
2
Record Selection. Make sure you use a selection formula that only returns those records that you need for the report, rather than having Crystal read and return all the records.
-
-
3
Indexes. Using database indexes can improve report performance significantly so try to use them when linking tables. Also, make sure the 'Use Indexes or Server for Speed' checkbox is checked on the Database tab of the Options dialog box. The Options dialog box can be opened from the File menu.
-
4
Linking Too Many Tables. One thing that can cause a report or sub-report to run slowly is the linking of too many tables. The more tables linked together, the slower the report will become. If you need to display data from multiple tables, try using a subreport to get data from one or two of the tables and storing that data in a shared variable for display later on. See the link at the bottom for more information on using shared variables.
-
5
Type of Linking. Another thing that can cause a report or sub-report to run slowly is the kind of linking that is done. An outer-join can slow the report down considerably. If possible, use an inner-join instead (assuming it will return the desired results).
-
6
Views. Creating and using a database view from a database query can encapsulate and simplify the data thus improving report performance significantly. This is one of the more advanced steps and may require a general understanding of database concepts.
-
7
Stored Procedures. Incorporating a database query into a stored procedure can also encapsulate and simplify the data thus improving report performance significantly. This is one of the more advanced steps and may require a general understanding of database concepts.
-
1
