Independent Data Consultancy
I had an interesting question from a new customer last week. They use Crystal Reports to analyse some data, but want users to be able to add comments to the report after it’s been run. No point adding them before, as the comments were a quote for work that was only known to be required […]
I recently met with a customer to discuss their requirements for some new Crystal Reports. In passing, they mentioned a problem they were having with the formatting of the Y-Axis on a chart. The problem was that the chart was being used to display a count, but values was displaying one decimal place which makes […]
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 […]
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 […]
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 […]
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 […]
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 […]
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 […]
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, […]
Customer: FTSE 100 Retailer Pursuit Technology installed Crystal Reports Server and trained the technical staff at a FTSE 100 Retailer in the administration and troubleshooting of the system. We have subsequently upgraded the server to a later release, adding Active Directory Single Sign-on. Technologies: Crystal Reports Server
