Aim:-How to tune the Performance of High Volume & Complex Business Logic Reports at Crystal Reports – 2008
Business Scenario: – To identify the cause for Reports which fetch high volume of data and run for a longer time before fetching the required results
In order to tune the performance of the high volume and complex business logic Reports at Crystal Reports 2008 we would be required to follow the below steps
1) Performance Tuning at the Data Base level (Source Level for Crystal Reports 2008)
a) Check and verify that the source data base used for the development of the reports at Crystal Reports 2008 is in normalized form.
Benefits: – It is always a best practice to have a normalized data base as a source for generation of reports.
b) Check if any indices (Cluster or non-cluster) which have been created at the database level should be created on integer field/value.
Benefits:-Crystal doesn’t have the concept of indexing, so it is recommended that indices shall be checked and set on integer value at the database level itself for faster search operation.
2) Performance Tuning at Crystal Reports – 2008 Designer Level
a) Try to check and verify that all the Groupings done at the Designer level is possibly done on a integer field.
Benefits:-The above setting will help the report to do a search faster for grouping the similar data as compared to string search.
b) Check that all the source tables used for Crystal Reports should have proper joins and links.
Benefits:-This will help the report to eliminate any integrity constraints before the report is executed.
c) Try to minimize the use of the controls such as Cross Tabs and Sub reports as much as possible to reduce the load while running the Crystal Reports.
Benefits:-Since the Crystal doesn’t have the concept of indexing, if we use a sub report control then Crystal will trawl through all the records in the subreport dataset sequentially until it finds a match.
d) Try to minimize the use of the special fields at crystal reports.
Benefits:-The execution time for special fields is comparatively more than the regular Crystal Reports in built functions.
e) Try to create formulas and running totals for only required business conditions.
Benefits: – This will reduce the over head and load while running the Crystal Reports.