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.

Features

  • Report using Stored procedure
  • Conditional formatting
  • Sub reports

Technologies

  • MS SQL 2005
  • Crystal Reports 10

Client Comments

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.