Migrating to SAP BI4 4.2 SP5 or Crystal Server 2016 SP5? STOP! UPDATE.

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. It looks like there’s a definite problem.I’ve had an odd reply from SAP that talks about moving files from DEV […]

Migrating to SAP BI4 4.2 SP5 or Crystal Server 2016 SP5? STOP!

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

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

Still have a single CPU licence for reports?

This is the first in a series of posts about licence compliance. It’s always difficult to get independent advice on licensing, so I’m attempting to highlight some potential pitfalls. Given the complexities and potential liabilities, you should always refer to your own licences. I’ve been trying to source some useful guidelines from SAP without success. […]

Crystal Dashboard in a Flash-free world

Hint: It involves HTML5! I first used Crystal Dashboard (then known as Xcelsius) in 2004 or 2005. Back then, the fact that the dashboards were deployed as Flash files was a selling point. Flash was available on over 90% of clients and Adobe had great plans for further developing the platform. Then, it all changed. […]

Buying from SapStore.com? You paid HOW MUCH?!? 2018 Update

(Updated August 2018 following SAP’s price rise) We don’t normally publish prices on this website. It’s not that we have something to hide, it’s just the complexity of SAP’s price list. There are two different distribution methods, each with its own price list. Each of these is potentially updated every month. That’s about 500 updates […]

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

SQL Server Standard 2016 – finally, a reason to upgrade!

Since MS SQL Server 2005, there have been 5 releases (2008, 2008 R2, 2012, 2014, 2016). Each new release came with some interesting new features – for those on the Enterprise Edition. For the majority of users, on SQL Server Standard, there were updates to the user interface and some security patches, but nothing to […]

Scroll to top