Archive for the 'News' Category



Service Pack 3 for Crystal Reports 2016

Friday 7 September 2018 @ 11:39 am

I don’t usually rush to apply service packs (i.e. ‘if it ain’t broke…’). Usually the fixed items don’t apply to what I do. So when SAP notified me about SP3 for CR 2016 I was ready to ignore it for a while. But I read through the list of fixes anyway, just in case, and the second to last item was something useful. It corrects a scrolling bug in the formula editor so we can now use the mouse wheel to scroll up and down in long formulas. I decided to do the update right away since I write lots of long formulas.

But the update was a hassle. It starts with 5 minutes of extracting files and then immediately pops up a “Fatal” error:

“Fatal Error: At least one port in the range 4520-4539 must be opened for the installation to proceed. …”

So why would a service pack for a locally installed app require access to ports? After a few searches I found that this is a red herring error message. It also occurs on some full Crystal Reports installs. The keys to getting past this error on a full install are to:

1) Run the setup from the Root folder
2) Use “Run as an administrator”.

But the service pack is a self extracting compressed exe. Placing the exe in C:\ and running it as administrator didn’t solve the problem for me. What worked for me in both Win 10 and Win 8.1 was to:

1) Use an Unzip utility (e.g. 7zip) to extract the compressed files/folders into a new folder.
2) Put this new folder in C:\.
3) Run the Setup.exe in this folder as an administrator.

Even then there was another snag.  The install couldn’t finish because of a “suppressed reboot”:

“A reboot request was suppressed on the local machine.
Reboot the machine in order to proceed with the installation”

But it wasn’t clear how to do this. My only options were “retry” and “cancel”.  So I cancelled, did a manual reboot and then ran the setup.exe a second time.  That allowed the SP to install and now I can scroll through my formulas.  It was just much more work than I expected.

Update 10/2/2018:

One of my readers just pointed out their own blog post about installing CR 2016 and having the same exact issues.   Had I seen that post when writing this one my post would have been a link to his.




Crystal Reports FAQ on the SAP website

Thursday 30 August 2018 @ 5:41 pm

I just stumbled across a FAQ on the SAP website that has some useful information. It was written in 2016 but the information still seems to apply. Many of the answers are links to other pages, like the link to the trial versions or the links to the service packs. I already had most of this information, but learned at least one new trick from the FAQ page.

Retrieving your License Key from the registry:

With older versions of Crystal you could go into Help > About and grab your complete license key.  This was helpful if you were changing hardware or installing on a second PC. With more recent versions you have to go into the license manager and you can only see a portion of the key. I recently had to track down a license key and wished I knew how to extract it from the PC.  Today I saw that 0ne of the tricks in the FAQ is how to find a full license key by searching the registry, using the portion of the key you can see in the license manager.  I’ll be ready next time.




Crystal Reports versions over time (2018)

Sunday 12 August 2018 @ 9:41 am

I do this chart each year based on my newsletter subscribers. It shows the version of Crystal Reports that they were using when they signed up for the newsletter. Over time, it shows which versions have staying power and how quickly new versions take hold. I have included numbers for 2018, even though the year is only about two thirds over. Those numbers will shift a bit in next year’s chart when 2018 is complete.

The chart shows that over 25% of my 2018 subscribers are still using Crystal Reports XI (circa 2005) which is version 11.x. Last year I was concerned that some of these users might really be on CR 2011 (version 14.o) since those do get confused.  But when I Emailed some of those people they all said that they were using the old XI version. For some of them, upgrading past Crystal Reports XI would be a major undertaking, because all the newer versions are limited to the .NET runtime. Customers that have built an application around the older runtime engine would have to rebuild the Crystal components of that app in order to upgrade to a later version of CR.

Version of Crystal Reports used by my new subscribers each year




The end of Crystal Dashboard Design

Tuesday 3 July 2018 @ 11:26 am

I just read an interesting blog post from Andrew Baines entitled “Farewell Xcelsius/BOB Dashboards/Crystal Dashboards“.

Apparently, SAP will stop supporting their dashboard tool some time next year, and they have dropped it from the price list. I also just checked the SAP “30-day trial” page and the listing for “SAP Crystal Dashboard Design” is no longer listed there.

I can’t say that I will miss this tool, since it never really fit with what I did. You can read my approach to dashboards here. But if you are using this software it is time to start looking for something else.




Review Crystal Reports and earn a $25 Amazon gift card

Friday 22 June 2018 @ 5:38 pm

The SAP Vancouver office celebrated the 25th anniversary of Crystal Reports last fall. They even sent me a commemorative pin as part of the celebration.

Now, in keeping with the ’25’ theme, they have asked TrustRadius to collect independent user reviews of Crystal Reports and Crystal Server. If you complete the process you get a $25 Amazon Gift Certificate.

Note that these reviews are structured and very detailed. I wrote a review of Crystal Reports, both to support the product and so that I could write about the process for my readers. It took me about an hour to complete. There are 9 different sections to the review and many of the sections ‘recommend’ at least 50 words. The sections are:

  • Use Case
  • Pros
  • Cons
  • Rating
  • Alternatives
  • Features
  • Data Sources
  • Data Sharing
  • Context

You can read my review here.

A few other notes.
1) TrustRadius is independent of SAP and SAP doesn’t see the reviews before they are published. However TrustRadius has to approve and publish your review before you get your gift card. It can take up to a week after your review is published to get the card.
2) Before you can start the process, you have to sign into TrustRadius using your LinkedIn account.

If you decide to write a review you can use this link. If you encounter any problems, let me know.




No current Crystal Reports certifications

Monday 23 April 2018 @ 11:15 pm

I have never been a fan of the SAP certifications for Crystal Reports. But if you were looking to be certified in the near future, it looks like there isn’t currently an option. I read this comment in an SAP discussion on certifications:

“Exam C_BOCR_13 [for CR 2013) is retired and no longer available and we do not have any information on an updated version.”

Once an exam is retired you can no longer take it. And if there is no ‘updated version’ then there is no way to take an exam for CR 2016, at least not through SAP. If anyone hears about an updated exam, let me know and I will update this article.




New SQL Server OLEDB provider supports TLS 1.2

Saturday 7 April 2018 @ 4:30 pm

If your organization handles sensitive information on the web (Credit Card info, HealthCare info, etc) you are probably using the latest TLS protocol (1.2). And if you are connecting to MS SQL Server through OLEDB, you may have had trouble connecting recently. This is because the SQLOLEDB provider and the SQL Server ODBC driver are no longer supported in TLS 1.2.

At the end of March, Microsoft released a new OLEDB Driver (MSOLEDBSQL) that does support TLS 1.2.

Thanks to Lyle Hardin of Foslyn LLC for sharing this info and links.




Crystal Reports versions over time (2017)

Wednesday 28 June 2017 @ 6:43 pm

I do this chart each year based on my newsletter subscribers. It shows the version of Crystal Reports that they were using when they signed up for the newsletter. Over time, it shows which versions have staying power and how quickly new versions take hold. I have included numbers for 2017, even though the year is only about half way there. Those numbers will change in next year’s chart when 2016 is complete.

The chart shows that over 40% of my 2017 subscribers are using Crystal Reports XI, which is over 10 years old. I was concerned that some users might really be on CR 2011 and confused the numbers. Those two versions get confused quite often. So I Emailed some of those people to see if that was a factor, but so far I haven’t heard from anyone who made that mistake.

I think the main factor is probably related to the runtime engine. For some CR customers, upgrading past XI would be a major undertaking, because all the newer versions are limited to the .NET runtime. Customers built an application around the older runtime engine would have to rebuild their app in order to upgrade to a later version of CR.

Version of Crystal Reports used by my subscribers each year




Security vulnerabilities in Crystal Reports web apps

Saturday 18 February 2017 @ 6:27 pm

A Crystal Reports web development team has posted in the SAP forums about some security weaknesses in the .NET web deployment model. They are trying to get the attention of SAP, without success so far.

It appears that this team deployed a .NET web application using the Crytal Reports runtime engine. During a security audit they uncovered some serious vulnerabilities. It appears that they weren’t able to get the SAP support team to look at the problem because they do not have a support subscription, so they posted it to the forum as three question. From what I have read they are trying to walk the line between highlighting the seriousness of specific vulnerabilities, while not making these same vulnerabilities easier to exploit.

Those of you who do .NET web development might want to check out the following links (some of which appear to have been deleted as of 3/6).

Link 1 (131436) (deleted)
Link 2 (130250) (deleted)
Link 3 (133449)

And thanks to Ido Millet of Millet Software for pointing these posts out to me.




Reduced prices for the “Expert” series

Sunday 8 January 2017 @ 11:29 pm

Starting this month, the prices for the “Expert” series of educational PDFs have all been cut in half. So if you were hesitant, maybe the new prices will make it easier to try them out.

Check out the full list of titles here along with the new prices.




«« Previous Posts
Jeff-Net

Recrystallize Pro

The Expert Series