Independent Data Consultancy
UPDATE This has now been fixed: SP4 from patch 000009 onwards SP5 from patch 000400 onwards SP6 For Crystal Server Users, you’ll need to go to SP6. For SAP BI, install the patches or SP6. First, if you’re just doing a fresh install with no old content to migrate then go ahead. 4.2 SP5 […]
Pleased to announce that Pursuit Technology are the first reseller for R-Tag’s Crystal Reports Management Software in the UK, covering UK and Ireland. We’ll be publishing a series of posts on these great products over the next few weeks with more details of the great functionality. In the meantime, if you’re looking for documentation, version […]
Eight years ago, I wrote a simple report viewer called RptView. Initially it was chargeable, then ad supported. One lesson I did learn is that neither of these models is a good way to make any money! I’ve now updated it to use a more recent version of Crystal Reports and you can now download […]
When you first start designing reports, you add tables using a wizard, work out the joins between the tables. Then you’re off. First report designed in no time at all. A few weeks later, you’ve designed all the easy reports. Then you learn to use subreports for that data that just won’t join. A little […]
Sadly, this no longer works. Google have removed the API. I’m hoping that the next release of Crystal Reports supports https for image locations so I can update this to a newer API. I just had an interesting support question from a customer, and felt the need to put pen to paper. They’re finding that […]
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 […]
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 […]
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, […]