Crystal Reports Redistributable Download

[Doris Joo]

Learnhow to download & install Crystal Report Runtime in this Tutorial. The SAP Crystal Report is the reporting tool that is used to design reports both in web and desktop environments. The Sap Crystal report has gone through name changes quite a few times, and the current version is named SAP Crystal Reports, a developer version for Microsoft Visual Studio. The last known name for the product was SAP Crystal Reports for Visual Studio 2010. You can go to Crystal Report Runtime download link and skip the introduction.

Choose the appropriate version of the report that i.e. 64bit or 32bit depending on your application. Download the runtime from the above link and save it to a folder on your hard disk. Unzip the content.

Hi

I have a question. I am trying to install crystal reports run time .msi file. How ever it installs by default in c drive

I have already installed crystal reports designer and server in d drive .

Is it possible to install the crystal report runtime in the location in d drive rather than installing it by default in c drive programa files SAPBUSINESSOBJECTS folder ?

Hola buen da, tengo una duda, si instalo este componente de Crystal Report en el servidor, adicional es necesario instalar una licencia de Crystal Reports completa?, en caso de esto ser si, Se debe instalar la misma versin del Crystal completo o si tengo una licencia anterior me funcionara?

thank you so much after days trying to get the solution, i am finally able to see my report. the SP installation works like a charm, changing all reference to the latest version according to my VS solved. I was working on moving the app to an upgraded server OS . the error i was getting was BusinessObjects.Licensing.KeycodeDecoder.dll not found. from there i dig and tried till this came to mind. thanks really helpful.

helped I have installed the last version of crystal report when I want to create a report viewer in the form issue tells me that crystaldecisions.shared version=13.0.2.000000

I have the latest framework installed

and crystal runtime the same version of crystal report

I have tried all thing but nothing solved

thanks

I have Crystal Report V-12.0.2000.0 installed on my Windows-10 development machine, which were working good along with my VS-2010 till I have updated my Windows-10 to its latest version (20H2).

It is not throwing any error however reports are not showing.

Could you please help me out here? Thanks in advance.

I have installed CRRuntime version: 13, on my machine. I have got text with Japanese font and want to export it as PDF, but instead of the Japanese font, I see boxes over there, I have investigated this issue and found that I should have Arial Unicode MS Font, I have also installed this font on my machine but still get the same issue, I am not able to figure out how to change font settings for CRRuntime. Any help will be appreciated.

Regards.

Hola buen da amigo, estoy teniendo problema con mi aplicacin de escritorio al momento de realizar la distribucin en las estaciones de trabajo que tienes sistema operativo de 64 bits aun cuando he cargado ambos .msi re tributable a la aplicacin de VB20015, de echo he realizada la instalacin del msi directamente en el cliente pero el error continua. sera que me puede orientar al respecto.

Might be something to do with versioning, who knows. Edit - Actually found this out. My parameters were created as a result of stored procedure parameters, they are always prefixed with an @ symbol. Regular parameters don't have that @ symbol.

2. This works great for Crystal Reports that query data directly from tables however not Crystal Reports that get data from stored procedures. I've not figured out the stored procedure bit yet but I'm still working on it. It looks as though it goes through all the tables in the Crystal Report and applies the log in information however I don't see any options to make it do the same with stored procedures. If anyone has any thoughts love to hear them.

Edit - Actually the above is not the case. It seems (at least in my environment) that any report with a parameter will fail with an error something like "Database Vendor Code 17". So I can run simple reports which don't have parameters on both tables and stored procedures but as soon as I put a parameter in I get the following error:

Error: 0x1 at Export Otago Data: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> CrystalDecisions.CrystalReports.Engine.InternalException: Failed to open the connection.

3. Make sure the versions of your DLL's are the same. If you mix up the DLL versions on the files your code may not compile. For example I have multiple copies of those files all with different version numbers: 12.1.1100.882, 12.1.2000.882, 12.2.1100.290 and 12.3.2000.601. That said three of my files are on the latest version and the CrystalDecisions.ReportSource.dll is on 12.2.1100.290 as I don't have a 12.3 version of it. Now it seems to work however when I've tried different file version combinations it complains.

5. If you are passing parameters don't forget to specify in the "Script Task Editor" dialogue box (you know, the one where you choose the language you want to write your script in) the variables in you SSIS package that your script will have access to. Simple mistake on my part but had me thinking for a couple of minutes.

The code below takes a few hard coded parameters and exports a Crystal Report to c:\report1.xls formatted in Excel Data Only format. You can change the export type to most things Crystal Reports supports, check out the ExportReport subroutine for the code. I've only coded to allow Excel Data Only (i.e. ExcelRecord), Excel, PDF and Word as we use those most here.

One thing that tripped me up a lot was the fact that I'm used to specifying server names that have SQL Server instances with square brackets around them, i.e. [ServerName\Instance]. If your data is on an SQL instance don't bother with the square brackets as the report will just time out with Database Vendor Code 17.

Cheers for the reply. I do have one thing I'm stuck on though. I've Crystal Reports 2008 installed on my local machine so of course I did all the development on my machine. It all works very well, the reports run, export to various formats etc.

Now the production machine does not have anything of Crystal Reports installed on it. So I figured I'd just copy the two DLL's to the same place on the production server (my machine is 64 bit as well as the production server) and then all should be good.

Unfortunately that's not the case. When I moved it to PROD it started complaining that it could not find the file or assembly CrystalDecisions.ReportAppServer.CommLayer.dll. So I copied that one across too and then re-ran things.

Anyone have any experience of releasing something like this to a system with no Crystal Reports stuff on it in the first place? Likely this is not the forum for this so I'll put in a ticket with SAP Business Objects and let you know how I get on just in case anyone else has something similar.

It's only a 25 MB file, once you unzip it you will find the file is called CRRuntime_12_0_mlb.exe. If you are using anything higher than IE 7 with that URL up there you will likely have no option to download anything. You'll need IE 7, Mozilla or Firefox (I had to get a colleague to download it as he was running Firefox). If you don't like that link you can try the following:

... and it will take you to the screen before which tells you what browsers are supported. From there you can click on "Get SAP Crystal Solutions downloads" then choose "Crystal Reports" from the Software Product drop down box then "Crystal Reports for VS .NET 2008" (well that's the version I'm using). When you expand the results to 20 rows per page the one I used was fourth from the bottom.

Just run this on the machine with no Crystal Reports components and your SSIS packages which call those two DLL's I referred to in an earlier post work fine. FYI, you will need a valid Crystal Reports 2008 product code to install this. There is one known bug in that you may get an error when trying to export to either Excel or Rich Text formats. If you get an error when exporting to those formats but you can export to PDF you need to copy the file from the following location:

... and put it in a location that is specified in your server PATH statement. For example I just put it in the Windows folder and everything worked. You can read more about this particular error in the following link:

They said there was a fix pack for it but it's 202 MB to download. Seems odd to me that the original installation was only 25 MB and the fix pack is 202 MB! So I just opted to copy the file. Alternatively you can just put the location where the file resides into your PATH statement however that will require a restart.

I'm not a Crystal Reports 2008 specialist at all which would explain why it's taken me four days to get this thing to work. So if any other SQL Server type folks need to do the same hopefully I've saved you some pain.

Thanks Chris again for you investigation and posting your results...I am sure it will help anyone doing this. I know I will refer to this when I have to configure a new server and get this running again.....I did go thru earlier entries in this post and noticed I had stated to install Crystal Report Framework For .Net 2.0 at this folder location or at least download it.

3a8082e126