Category Archives: 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 reports. Large queries… Read More »

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 while later, you… Read More »

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 of the data.… Read More »

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 the final export… Read More »