Crystal Reports & SQL Reporting Services Training Consultants
Account Log in:
Username:
Password:
A wise person learns by the experience of others. An ordinary persons learns by his or her own experience. A fool learns by nobody's experience
 
Institute of IT Trainers - Freelance Trainer of the Year 2006 & 2009
Liverpool Business Connect Member
  Maximum Impact Solutions Limited - Reporting Solutions, Creating Answers
Reporting Solutions - Creating Answers, Crystal Reports, Dashboarding (Xcelsius) & SQL Reporting Services
Crystal Reports & SQL Reporting Services Case Studies

Company
Maitland Services Limited

Issue
The client had designed a utilisation report, using SQL Server Reporting Services 2008, for the company, however although the report return the correct data, it took over 10 minutes to execute.

Solution

It was decided that the most effective solution would be to provide a remote report consultancy solution, that would primarily look at the performance issues of the report.

The client emailed across the report and the underlying SQL statements of the report and the report parameters.

Reviewing of and amendments to the SQL statements, significantly reduced the execution time of the report, resulting in inceased report performance.


There are currently no comments for this case study

Back

Crystal Reports & SQL Reporting Services Training, Consultancy, Report Writing, Support & Maintenance