Tips for Crystal Reports Performance improvement

·        To provide the best performance possible, a Reporting Best Practice is to have all calculations take place in the SQL engine rather than in the reporting tool.

As a rule of thumb, only the data required to display the information should be transferred to the report. Data processing on the database side is much more efficient than inside the reporting tool.

·        Don’t drag   tables /Views in the database expert; it will get all the data in the tables instead use Custom SQL query. You can add this in the command.

·        Use record sort expert in crystal instead of order by clause in query wherever possible.

·        Put Most of the complex logic in query level using case, decode.... etc functions instead of crystal formulas.

·        Avoid groupings if it is not required. Don’t group the fields just for sorting instead use record sort expert.

·        Reporting Best Practice is to explicitly specify the fields in the select statement.

·        If possible get all the sections logic in single sql query and design report without sub reports.

·        We can use Union /Union all in the query and combine the similar datasets and design the report without sub-reports.