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 […]

Caching queries using SQL views

A customer approached us as they were having problems with report performance. The problem related to a report being based upon a view that took 90 seconds to run. I didn’t think that was too slow until they told me that there were hundreds of concurrent reports all hitting the same query. First response was to […]

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 […]

Using Temporary Tables with Crystal Reports

I recently wrote a Crystal Report for a customer that queried their recurring bookings for gaps of more than 45 minutes. Easy enough, just sort the report by booking time and use Crystal’s previous() and next() functions to work out when the gap’s too large. A little conditional formatting to hide the rows without gaps, […]

Scroll to top