Intel’s Meltdown and database performance

Unless you’ve been on an extended Christmas break with no TV or Internet, you’ll have heard of Intel’s recent troubles. While it’s true that most computers will not be noticeably affected, servers that read and write large amounts of data to disk will be impacted. In my world, that affects two things – databases and […]

Another way to remove subreports from Crystal Reports – ListAgg

I always enjoy tuning reports for customers. I guess it’s the same satisfaction that people get from doing crosswords – a problem is presented (poor performance), you just settle down and work through the problem bit by bit. First thing I do is to review the subreports. While a subreport can be an essential part […]

Sparkline charts in Crystal Reports!

I had an interesting time at a customer site recently. They were converting reports from Excel (ugh) to Crystal Reports. The Excel reports involved multiple queries and took most of a day to generate, so the promise of generating in a few minutes from Crystal Server was very appealing. Then we realised that the sparkline […]

Using Database Triggers to increase information available to report designers

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 […]

Why oh Why my Y-Axis, or what part of integer don’t you understand?

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 […]

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 […]

Using Temporary Tables with Crystal Reports

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, […]

Crystal Reports and image transparency

It’s long been a complaint that if you insert an image into Crystal Reports, the transparency is lost. It came up again in a support call from a customer. Glad to say I’ve found a solution – use Crystal Dashboard/Xcelsius. It works well too: Start up Crystal Dashboard, insert your various images, using the Excel […]

Scroll to top