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…

Oldie, but goodie? Running old software, but need updates.

In the past 6 months, I’ve worked with customers running every version of Crystal (Reports, Server & Enterprise) since version 7. Next week I’m running an XI R2 training course. Today, I helped an engineering company with a Crystal Reports 9 problem. As much as we’d all love to be running with the latest and…

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…

Crystal Service Packs – time to take a bit more notice

I’ve always thought that Service Packs for any product were a way of fixing bugs in software after release. If a software company wanted to introduce new features, they waited until the next full or point release. When I install software, I always patch to the latest Service Pack. I normally leave any in-between patches…