Report performance tuning

Customer: Aviation Software House Our customer had an important report that was taking over 10 minutes to run for just a month’s worth of data. New requirements mean that the report needed to be run for a year’s worth of data. Obviously a problem! As is so often the case, the main performance problem was…

Configuring Crystal Server’s RAS to scale to 1000s of report views per minute

Customer: Educational Software Company SAP introduced us to a rapidly growing software company. The reported problem was a with scaling their Crystal Server. The server was using the Report Application Server (RAS) to modify reports on the fly, then present the finished report to the user. We initially expected the problem to be related the use…

Custom Development of integrated viewer

Customer: Construction Consultancy Our Partner’s customer, a construction consultancy, needed a custom report viewer integrating into their web application. Pursuit Technology provided a Visual Studio ‘User Control’ to allow the reporting to be very loosely coupled with their main application. The final integration provided a dynamic report list that presents a list of reports to…

Advice on integrating Crystal Reports runtime into a web application, including license implications

Customer: Security Software Company Our Partner’s customer required advice on the best way to integrate reporting into their database security software. Pursuit Technology’s long experience of Crystal Reports integration work allowed us to advise them on both the technical and legal issues around the integration. Technologies: Crystal Reports

Design and development of Data Warehouse including ETL using SQL Server Integration Services. Design of Web Intelligence Reports.

Customer: Market Leading Leisure Organisation We  planned and implemented data migration from multiple source systems into a final data warehouse from which Web Intelligence Reports were created using Universes. Some additional Crystal Reports were also created. Much of the data came from legacy systems so robust procedures were put in place to ensure the accuracy…

Specialist Crystal Report design with a focus on ‘perfect’ exports to Word and Excel.

Customer: FTSE 100 Utility The FTSE 100 Utility required very accurate formatting in Crystal Reports. The final reports were to be used for sending out quotes in both pdf and word format. As any frequent user of Crystal Reports knows, this can be an error prone task with seemingly trivial changes to a report changing…

End to end reporting solution, from data warehouse design through to SharePoint integration

Customer: Diagnostic Imaging Provider Project: End to end reporting solution, from data warehouse design through to SharePoint integration. Pursuit Technology were responsible for enabling reporting across multiple disparate systems. A reporting database (datamart) was designed in Microsoft SQL Server, loaded on a daily basis using Microsoft SQL Server Integration Services. The reports were initially intended…

Specification of infrastructure, installation and configuration of Crystal Reports Server for financial organisation

Customer: Canary Wharf based financial organisation Pursuit Technology partnered with an IT infrastructure company to assist their new customer with their reporting needs. Crystal Reports Server had already been chosen in recognition of its market leading reporting technology. Initially, Pursuit Technology were involved in planning the number of servers required to allow for development, testing…