Export reports in web cloud server

[former_member603666]

Hi sap users,always is a pleasure ask to you.

This time the next question:

I have some reports in Crystal for Visual Studio and works fine in my PC. These reports works fine in my PC, and after publish in IIS, including on a local server.

The problem is, when I put those reports in a web server cloud. no matter what I am doing, the report is not shown.

I use a direct report with the ip of the server, also create a variant of the report with DataTable. Even a datasource was created with the ip of the server...and it didn´t work in any way.

This situation only appears in the web cloud server, in my PC, After publish in my PC and in the local server works fine. Then my question is: a permit is needed to export Crystal Reports in a web cloud server or I need to do something special to show the reports?

Thank you so much for your attention, have a nice weekend.

[former_member603666]

I almost forgot to show you the error of the web page:

[DellSC · Accepted solution]

Did you install one of the runtime installs on the cloud web server? You can't just copy over files when you deploy your application, you have to actually install the runtime version that corresponds to the version you used when developing your application. This is because some of the SDK is still based on COM so it has to update registry keys, which get done during the install. Also, when you run the runtime install, you MUST be logged in to the server with Administrator rights or else everything doesn't get registered and configured correctly.

-Dell

[former_member603666 · Accepted solution]

Thank you so much for the answer. I have the runtime, but the problem is I can´t install in that server, because I don´t have the license to install visual studio in that server.

Is there a form to install the runtime without having installed the Visual Studio? Or I need to buy a license for the server?

Thank you again.

[former_member603666 · Accepted solution]

Now this is the problem

[DellSC · Accepted solution]

The install for VS is not the same as the runtime install. You need to go to here: https://www.crystalreports.com/crystal-reports-visual-studio/, provide your name and email, and it will take you to the download page. On the download page, the orange button downloads the .exe that integrates into VS. The blue buttons below it are the various runtime install options that are available for deploying applications. You'll need to download one of those to install on the server. You also need to make sure that the SP that you used in VS matches the SP of the runtime. If it doesn't, then you need to download the latest version for VS, install it, and recompile your app so that it will work with the latest version of the runtime.

-Dell

[former_member603666 · Accepted solution]

Thank you so much again. The runtime is already installed and it matches with the SP, but now is trowing the next error:

[DellSC · Accepted solution]

Is it saying that it is unable to connect to the database? If so, are you setting the database connection in your code? If it's using ODBC, do you have the correct ODBC connection configured on your server?

For sample code that will log in to the database (Crystal doesn't save passwords internally...) see this blog post for sample code: https://blogs.sap.com/2016/02/17/how-to-parameters-in-crystal-reports-for-visual-studio-net/

[former_member603666 · Accepted solution]

Thank you so much, the issue is finally solved. The problem was the mysql driver (The version was old). When the driver was update, the reports works normally.

Thank you so much.