Pursuit Technology, SAP Crystal Reports Freelance Consultancy and SAP BusinessObjects Freelance Consultancy

Case Studies

Due to the nature of our business, it's not normally possible to release customer names. The following are anonymous examples of work undertaken.
CustomerProjectWith a PartnerDetails
Diagnostic Imaging ProviderEnd to end reporting solution, from data warehouse design through to SharePoint integration.YesLess
Pursuit Technology were responsible for enabling reporting across multiple disparate systems. A reporting database (datamart) was designed in Microsoft SQL Server 2005, loaded on a daily basis using Microsoft SQL Server Integration Services. The reports were initially intended to be produced on a monthly basis. However, this soon changed to daily once the business benefits became clear.
For report generation, Crystal Reports Server 2008 V1 was used with custom code produced by Pursuit Technology enabling reports to be viewed from the company's SharePoint site. By using custom code rather than the normal SharePoint integration, a modified view of the report list could be produced to simplify report consumption. In addition, the Crystal Server licenses could be Less easily managed to avoid all the problems associated with users holding a license when they fail to logout.
    Technologies:
  • Crystal Reports Server 2008 V1
  • Crystal Reports 2008
  • Windows Server 2003 64 bit
  • Microsoft SQL Server 2005
  • Microsoft SQL Server Integration Services 2005
  • Microsoft SharePoint
  • Visual Studio 2008
  • C#, aspx
Canary Wharf based financial organisationSpecification of infrastructure, installation and configuration of Crystal Reports Server.YesLess
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 and UAT of Crystal Reports, followed by Live and Disaster Recovery Servers.
Their three servers were installed over two days on VMware Infrastructure, complete with Active Directory Single Sign On. The publishing process was then fully documented and tested in their environment before going live.
Security was setup using AD groups to allow central administration of all users through Active Directory.
    Technologies:
  • Crystal Reports Server XI R2
  • Crystal Reports 2008
Market Leading Leisure OrganisationDesign and development of Data Warehouse including ETL using SQL Server Integration Services. Design of Web Intelligence Reports.NoLess
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 of the data.
    Technologies:
  • Business Objects XI R2
  • Business Objects Universe Designer
  • Web Intelligence XI R2
  • Crystal Reports XI R2
  • Microsoft SQL Server 2005
  • Microsoft SQL Server Integration Services 2005
FTSE 100 UtilitySpecialist Crystal Report design with a focus on 'perfect' exports to Word and Excel.YesLess
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 the final export formatting significantly..
Pursuit Technology's long experience with Crystal Reports ensured that we were able to produce reports with the very exact formatting required for the task.
To ensure costs were kept to a minimum, a sample database was sent to Pursuit Technology's office so that all work on the reports could take place remotely. This increased the flexibility we were able to offer as we could then charge by the hour rather than the Less common day rate.
We have now worked on three projects with client and look forward to future work.
    Technologies:
  • Crystal Reports XI R2
  • Oracle 10g
FTSE 100 RetailerInstallation and technical training of Crystal Reports ServerNoLess
Pursuit Technology installed Crystal Reports Server XIR2 and trained the technical staff at a FTSE 100 Retailer in the administration and troubleshooting of the system.
    Technologies:
  • Crystal Reports Server XI R2
Major B2B Media GroupUpgrade of old Crystal Enterprise 10 custom code to .Net with C#YesLess
Until the XI R2 release of Enterprise, most custom development work was done using the old Crystal Server Page technology. Fortunately, Pursuit Technology have experience in custom development from the first release of the old Crystal Enterprise to the latest Business Objects XI 3.1.
Our Partner's customer, a B2B media group had an important internal web application written using this old technology. For them to upgrade to Business Objects XI R2, this had to be upgraded to run on a .Net platform.
Pursuit Technology were able to offer a fixed price upgrade service, and the code was successfully upgraded to C#.
    Technologies:
  • Business Objects XI R2
  • Visual Studio 2005
  • C#
  • Crystal Server Pages (csp)
Major City Council's ICT departmentCustom development to allow windows application written in Foxpro to interface with custom Business Objects Enterprise viewer.YesLess
Our Partner's customer had a Windows application that needed to integrate with Business Objects Enterprise XI R2. Few organisations have experience of Windows development with Enterprise due to it's web focus. Fortunately, Pursuit Technology were able to help.
Our C# application was called from the customer's FoxPro application allowing use of the Business Objects security, Business Views and Crystal Reports. This provided a secure, scalable solution for reporting within a Windows application. This is now used on many customer sites.
    Technologies:
  • Crystal Reports Server XI R2
  • Crystal Reports XI R2
  • Business Views
  • Visual Studio 2005, Windows Development
  • C#
County CouncilUpgrade of Crystal Enterprise 10 Server to Business Objects XI R2YesLess
Our Partner's customer had an important installation of Crystal Enterprise 10. Pursuit Technology helped to upgrade this to Business Objects Enterprise XI R2, migrating all the existing content to the new installation. Following the successful project, we were able to provide informal training on the new version.
    Technologies:
  • Business Objects Enterprise XI R2
National Software CompanyResearch and advise on most suitable reporting technology for their market leading software suite.NoLess
Pursuit Technology were approached by a leading software company to provide help and advice on which current Business Intelligence software best met their integrated reporting needs.
As a trusted 3rd party, we were able to analyze their requirements and make a recommendation for their future integration work.
    Technologies:
  • Just an independent point of view
London-wide public sector organisationResearch and advise on most suitable technology for analysing cross-borough dataNo
Automotive DealershipRemote technical supportNoLess
Pursuit Technology were approached to provide support and consultancy for an existing Crystal Enterprise 10 installation. The system had been in place for some years and now there were a number of problems that needed to be solved.
Over several sessions, we were able to remotely connect to their server to review the problems. Most importantly, we were then able to replicate the issues using our Virtual installations and then test proposed solutions without any impact on the customer's mission critical server.
Finally, the solutions were implemented at a convenient time for the customer.
    Technologies:
  • Crystal Enterprise 10
Construction ConsultancyCustom Development of integrated viewerYesLess
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 a user depending upon their security settings. By using Crystal Reports rather than Business Objects Enterprise, a very tight integration with the application's security model was possible with very little software licensing cost.
    Technologies:
  • Visual Studio 2005
  • Crystal Reports 2008
  • C#
FTSE 100 MinerUpgrade of Crystal Enterprise 10 Server to Business Objects XI R2No
Cisco PartnerReport design for Cisco Partner's end users-Less
Pursuit Technology were tasked with writing Crystal Reports from a Cisco Unified Contact Center Express database. Once written, the reports then required the Cisco meta-data to allow them to be integrated with the Cisco application.
    Technologies:
  • Crystal Reports XI R2
  • Cisco Unified Contact Center Express
  • Microsoft SQL Server 2005
Security Software CompanyAdvise on integration Crystal Reports runtime into web application, including license implications.YesLess
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 2008
  • Application Integration
Major UK CharityRemote report designNo