The project was to optimizing the LTA management report. The scope of this project is to try to use stored procedures and/or views in order to make it quicker and to suggest/implement a different and faster layout for some sub reports.
The report prior to optimization took around 3-4 hours to display records when in after optimization it takes only 10-15 minutes ( on first run) and then approx 5 minutes and the optimized report also is exportable to excel without losing the formatting.
- Report using Stored procedure
- Conditional formatting
- Sub reports
- MS SQL 2005
- Crystal Reports 10
Rajendra is an excellent coder. He submitted his work always on time. He is a A class “Crystal Reports” magician. He made the impossible to be possible. And we are greatful.