Skip to Content
author's profile photo Deewakar Kumar
Deewakar Kumar

Not able to generate Crystal Report

Posted on Jan 11, 2019 at 06:50 PM 375 Views

Hi All,

Currently we have upgraded our application to dot net framework 4.7.2 to support TLS1.2. We have deployed our application on windows server 2016.Earlier we were using windows server 2008 R2 SP1. The issue is that we are not able to generate crystal report from our new windows server 2016.The crystal report is installed on this new server. The crystal report version is Crystal Report XI R2 SP2. When we point our crystal report virtual directory to old windows server 2008R2 we are able to generate pdf report.But not on new server. So do we need new version of crystal report viewer on new server?

SAP Crystal Reports, version for Visual Studio SAP Crystal Reports viewer
Add comment
10|10000 characters needed characters exceeded

3 Answers

  • Best Answer
    author's profile photo Don Williams
    Don Williams
    Posted on Jan 11, 2019 at 06:52 PM

    To be able to support TLS 1.2 you need to update the MS SQL Client to Native 11 driver but I don't think XI R2 is aware of the new driver so it likely won't work.

    Time to upgrade to your reports to CR 2016 or above.

    You can get CR from here:

    https://www.sap.com/products/crystal-reports.html

    And search for this KBA -

    2269180 - Disabling TLS 1.0 may cause Crystal Reports Designer and .NET application to fail to connect to your MS SQL Server Database 2012/2014

    And you will need to update your app in VS 2010->2017 and use the update CR runtime:

    https://wiki.scn.sap.com/wiki/display/BOBJ/Crystal+Reports%2C+Developer+for+Visual+Studio+Downloads

    Don

    Add comment
    10|10000 characters needed characters exceeded

    • Deewakar Kumar
      Jan 18, 2019 at 01:24 PM

      Hi Don,

      I have one more doubt.

      I have Sap Crystal Report 2016 Sp6 version 14.2.6.2839 as well as Sap Crystal Report Runtime Engine for .Net Framework version 13.0.24.2970 installed on my developement environment which is currently Windows 7 and I am able to successfully generate pdf report. Yesterday I set up my code on new developement machine which is windows 10 and I only installed Crystal Report Runtime for dot net framework mentioned above and I was also able to successfully generate pdf reports on windows 10 machine.

      So my question is that do we need only runtime version for upper environment ( Which are Windows server 2016 ) like QA, UAT and Prod or both i.e. Runtime as well as Sap Crystal Report SP6 as I am able to generate pdf reports with only runtime on my new windows 10 developement machine.

  • author's profile photo Deewakar Kumar
    Deewakar Kumar
    Posted on Jan 17, 2019 at 03:55 AM

    Thank You Don.

    Installing latest Crystal Report Runtime solved my issue.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo Don Williams
    Don Williams
    Posted on Jan 18, 2019 at 04:39 PM

    Only runtime is needed on the app server, they are basically the same.

    You only need CRD installed if you want to edit the reports.

    Add comment
    10|10000 characters needed characters exceeded