We’ve been helping student accommodation providers report and analyse their Starrez data for over 5 years. The built-in reports are fine up to a point, but most users soon need a little more. Whether you’re using StarRez installed on your own servers, or in the cloud, the data is there waiting for you. It’s great […]
Category: Case Studies
Staffplan Reports? Don’t know your tblActuals from your tblBookings?
Not forgetting tblRegularInfo! It’s said that you need 10,000 hours of practice to become an expert in something. We’ve spent 11 years working with the Staffplan database. In that time, we’ve written close to 600 reports, dozens of Dashboards and 100+ views and stored procedures. We’ve even integrated a 3rd party text message system to […]
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 […]
Capsule CRM reporting using Crystal Reports
Customer: Care provider Our customer switched to Capsule CRM to handle their recruitment process. Capsule provides a really efficient way to create and monitor the recruitment workflow from first contact through interviews to training. Problem is, the database is ‘up there’ in the cloud. Typically of many cloud platforms, the focus is on data in. […]
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 […]