Crystal Report Design

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

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

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