Crystal Report 11 R2 Deployment Visual Studio 2008 .NET 3.5

[Former Member]

Hello Everyone,

It is quite frustrated with my web applications using CR 11 Developer Edition & Visual Studio 2008 .NET 3.5.

I used to work with VS 2003 .NET 1.1 & CR 11, designed the reports in CR11 and used the CR.NET that come with VS 2003.. to automate exporting the reports to PDF (Portable Document Format) and they have been worked perfectly fine on local dev machine with the actual software installed & development/production servers with the merged modules package installed ( CrystalReports11_NET_EmbeddedInstall.msi ).

I recently got upgraded to VS 2008 .NET 3.5/downloaded/installed the CR11 R2 on my development machine & the servers got upgraded to .NET 3.5 with still have the runtime CrystalReports11_NET_EmbeddedInstall.msi >> I keep getting error, " Could not load file or assembly 'CrystalDecisions.ReportAppServer.CommLayer, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified." when I try to export to PDF. I was told by Bus. Obj. CR Tech Support that I need to download the cr_net_mm_en.zip and install on the server (this merged modules released on 2005, but VS 2008 .NET 3.5 did not release until after 2005, it seemed doesn't make sense!!!) & from MSDN's forum posted that I need to install CRRedist2008_x86.msi which located in the \Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5 , but the thing is I have CR11 R2 not version 10.... I have been read too many help documents/posts regarding this issue since yesterday, but the more I read the more I got confused... honestly at this point I am not exactly sure which one I should install on the server... my current situation is that our dev server was down and the production is currently running, I just don't want to install the wrong one... PLEASE HELP!.

Many thanks in advance for your help.

Regards

--Iris

[Former Member · Accepted solution]

Iris,

Appreciate if you can help me.

I used to work with VS 2003 .NET 1.1 & CR 11, designed the reports in CR11 and used the CR.NET that come with VS 2003.. to automate exporting the reports to PDF (Portable Document Format) and they have been worked perfectly fine on local dev machine with the actual software installed.

But in production server it is failing and when I downloaded merged modules package CrystalReports11_NET_EmbeddedInstall.msi and tried to install it is asking for Product Id.

Please let me know the product ID of this or from where I can get this.

I downloaded this CrystalReports11_NET_EmbeddedInstall.msi from link

https://wiki.sdn.sap.com/wiki/display/BOBJ/Crystal%20Reports%20for%20Visual%20Studio%20.NET%20Runtim...

[Former Member · Accepted solution]

Hi Santosh,

Yes, it is required the Product ID at the time our Server Admin install the merge modules. This Product ID is the same as the one you use to install the actual software on your local development machine. The Product ID is usually come along with your software purchase invoice confirmation message from Business Oject CR or directly from the CR Sale Rep.

I hope this help!

Regards,

--Iris

[Former Member]

Hi Santosh,

The link you provided is not working it is appreciate that you send me the link for downloading.

[former_member183750]

Try this link:

Crystal Reports v. 9.1 to SAP Crystal Reports, developer version for Microsoft Visual Studio Runtime...

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow us on Twitter

[Former Member]

Thanks so much again. I redesigned the report, but having problem with reading the data. I created the report from scratch within Visual Studio 2008, and make the connection work under DATABASE EXPERT on my local machine, then update with the data path on production, I got error below. PLEASE ADVISE!

Thanks a millions,

--Iris

"CrystalDecisions.CrystalReports.Engine.LogOnException: Logon failed. Details: ADO Error Code: 0x Source: Microsoft JET Database Engine Description: The Microsoft Jet database engine cannot open the file '
lusun\eds\DB\VF.mdb'. It is already opened exclusively by another user, or you need permission to view its data. SQL State: 3051 Native Error: Error in File C:\WINDOWS\TEMP\temp_fa033553-2404-4bc8-bbce-609af58a34c3 {1DC0E967-08D6-4EF7-B913-FE44540AA36C}.rpt: Unable to connect: incorrect log on parameters. ---> System.Runtime.InteropServices.COMException (0x8004100F): Logon failed. Details: ADO Error Code: 0x Source: Microsoft JET Database Engine Description: The Microsoft Jet database engine cannot open the file '
lusun\eds\DB\VF.mdb'. It is already opened exclusively by another user, or you need permission to view its data. SQL State: 3051 Native Error: Error in File C:\WINDOWS\TEMP\temp_fa033553-2404-4bc8-bbce-609af58a34c3 {1DC0E967-08D6-4EF7-B913-FE44540AA36C}.rpt: Unable to connect: incorrect log on parameters. at CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions pExportOptions, RequestContext pRequestContext) at CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext reqContext)"

Edited by: IrisVT on May 27, 2009 3:38 PM

[former_member200290]

Hi Iris,

Well this can be a few things:

1 - The person running your application does not have permissions to this directory/file:
lusun\eds\DB\VF.mdb. This has to be fixed by the network administrator.

2 - The file
lusun\eds\DB\VF.mdb' is open in exclusive mode by another aplication. Not much can be done except close the other application.

3 - The files is in another location then
lusun\eds\DB\. You will need to programmatically set table location.

4 - The file
lusun\eds\DB\VF.mdb has password protection that you will need to supply at runtime.

Trevpr

[Former Member]

Thanks SO MUCH Trevpr for your quick response. Would you please show me how to programmatically set table location that you meant about.

Thanks & thanks a millions.

Regards,

--Iris

[Former Member]

Below is my code in case you need it:

sql = SELECT ... FROM test WHERE VID =808

cnn = New OleDbConnection(ConfigurationSettings.AppSettings("AccessDBCnn"))

da = New OleDbDataAdapter(sql, cnn)

da.Fill(ds, "VFInfoRPT")

da.Dispose()

cnn.Close()

rpt.SetDataSource(ds.Tables("VFInfoRPT"))

..... my exporting path stuffs is here .......

With rpt.ExportOptions

.ExportDestinationType = ExportDestinationType.DiskFile

.ExportFormatType = ExportFormatType.PortableDocFormat

.DestinationOptions = crDiskFileDestinationOptions

End With

rpt.Export()

PLEASE HELP.... This routine is work perfectly on my machine with a local access database, the error is only generate once I changed the database path to match with production server. I have spent so SO much time researching on the issue so PLEASE HELP!!!.

Thanks,

--Iris :-(((

Edited by: IrisVT on May 27, 2009 9:51 PM

Edited by: IrisVT on May 27, 2009 11:56 PM

[Former Member]

I forgot to mentioned that the path *
lusun\eds\DB\VF.mdb* I specified in the DB connection, which included in the error is one of the trails I performed to see if it work along with my user id & password login to the server. I have the code above, so would you please advise! Any suggestions!

Thanks a millions.

Regards,

--Iris (

[Former Member]

My problem with Crystal Report 11 R2 vs. Visual Studio 2008 .NET 3.5 has been resolved. My actual problem is that joining multiple tables in design does not work with VS 2008/CR 11 on production with runtime package installed. My solution is purchasing CR 2008.

Thank you so much for all of your help/suggestions.

Regards,

--Iris

[Former Member]

Thank you SO MUCH once again for all of your response. We did install the CR 10 runtime on the server. Now I get a different error below. I understand that I can go to the the CR .NET's Field Explorer to change the DB path, pointing to the server, but the thing is, if I do that I will lost all of the drag & drop report DB param values on the report, which mean like I have to re-design the report >> this would be a pain. PLEASE ADVICE for any working around methods!!!.

Thanks a millions.

Regards,

--Van

Edited by: IrisVT on May 22, 2009 11:04 PM

[former_member200290]

You are very welcome for the help. I am not 100% sure I am following what is happening, it is hard to get a complete picture over a forum post. However what it sounds like to me is that you are trying to use your XI R2 reports in Crystal 10.5 for Visual Studio 2008 . When importing into the 10.5 version you are having to change database drivers as 10.5 is a basic or limitted version which does not have all the features and database connectivity of the full release.

It sounds like this is the issue you are having. Unfortunately there is not much you can do besides the options you have:

- Redesign the reports

- Update to a version of Crystal that works with VS 2008 that has a full feature set

- Downgrade to the last version of Visual Studio that you were using that worked with Crystal XI R2.

Really the situation you are in is like going out and purchasing a Nintendo WII then buying a really cool XBOX 360 game and trying to get the two to work together. It won't happen.

I work in support and am not in sales. When I am helping out on the forums I do not look at the forums as a way to sell. I am here purely to help out the best I can over the forums. To me it sounds like the easiest thing for you to do is update to Crystal 2008. Now on your test development environment I would download the trial copy and see if this gets things to work. If it does upgrading may save you many hassels.

Trevor

[former_member200290]

Hi Iris,

Visual Studio 2008 is not on Crystal Reports R2 (11.5) supported platforms list, VS 2005 is the last version of Visual Studio that Crystal R2 was tested on.

I have heard of other users doing development with R2 and VS 2008 and getting it working, however I have also heard more developers running into troubles. Myself out of curiosity have tried VS 2008 with R2 and couldn't get it to work correctly.

My suggestion to you would be one of the following:

If you have to use Crystal R2:

- Stick with VS 2005 or earlier

If you have to use VS 2008:

- Use the Bundled 10.5 version of Crystal. This version does not have all the functionality of a full build. (Follow Jon's suggestion in the previous reply)

- Update to Crystal Reports 2008 (at least SP1 would be recommended).

I hope this helps you out,

Trevor

[Former Member]

Thank you so much once again. I spoke to CR Sale Rep. this morning and would love to upgrade to CR 2008, but the problem is I cannot do the upgrade at this point & I do not have VS 2005. The only choice I have now is "*stuck with CR 11 & VS 2008*". Please help me with the questions below:

1-- The *CRRedist2008_x86.msi * is a FREE runtime package right? If I have a license for CR11 Developer Edition, will I legally install this .msi on production server for commercial uses?

2-- If I install this runtime *CRRedist2008_x86.msi* on production, will other applications using .NET 1.1 with CR 11's runtime *CrystalReports11_NET_EmbeddedInstall.msi* still work??

3-- You mentioned that other users doing development with CR11 R2 and getting it to work! Do have the guidlines from those users that I can try?

Many thanks in advance once gain for your promptly response.

I look forward for your response.

Regards,

--Iris

[former_member200290]

1-- The *CRRedist2008_x86.msi * is a FREE runtime package right? If I have a license for CR11 Developer Edition, will I legally install this .msi on production server for commercial uses?

CRRedist2008_x86.msi is for the 10.5 version (the bundled version) of Crystal. As you have VS 2008 you can distribute this legally. You can use this runtime to run your reports. The only thing is if you built reports in 11.5 version of Crystal they may not function correctly with the 10.5 version.

2-- If I install this runtime CRRedist2008_x86.msi on production, will other applications using .NET 1.1 with CR 11's runtime CrystalReports11_NET_EmbeddedInstall.msi still work??

This will work side by side with other versions of Crystal. As long as each application references the version of the dlls they need.

3-- You mentioned that other users doing development with CR11 R2 and getting it to work! Do have the guidlines from those users that I can try?

No. If I had the parameters I may have been able to get it to work myself. All I have had is "oh I have gotten it to work no problem." But nothing more then that.

The only difficulty in getting this to work, is if you do get it to work and you run into an issue the only way we can track a fix request is if the behaviour is duplicatable in a supported environment.

The only choice I have now is  "stuck with CR 11 & VS 2008" . 

If that is the case then it sounds like the best option is to use the bundled version of 10.5 that comes with Visual Studio 2008.

Trevor

[Former Member]

I am sorry for bothering you gain, but please help me understand the belows if I install the CRRedist2008_x86.msi, mainly regarding your response to my #2 question above. You said that, "This will work side by side with other versions of Crystal. As long as each application references the version of the dlls they need.":

2a)) Will installing CRRedist2008_x86.msi overwrite the installed CrystalReports11_NET_EmbeddedInstall.msi files? Is there a way that I can specify a different location without causing any conflicts between these 2 runtime packages/.DLLs files?

2b)) Where can I go to specify the versions of the .DLLs for each application references on Window Sever 2003? I couldn't found anywhere in the property window of the IIS's web application virtual directory on the server. I assumed you meant doing the references of .DLLs versions is on the server under IIS! (I have tried to individually adding the DLLs to the references of each web application on my development machine and then complie/publish to production, I got error above, "Could not load file or assembly 'CrystalDecisions.ReportAppServer.CommLayer, Version=10.5.3700...").

Thanks again,

Regards,

--Van

Edited by: IrisVT on May 22, 2009 2:09 PM

[former_member183750]

Hello Iris:

2a)) Will installing CRRedist2008_x86.msi overwrite the installed CrystalReports11_NET_EmbeddedInstall.msi files? Is there a way that I can specify a different location without causing any conflicts between these 2 runtime packages/.DLLs files?

- there will be no conflicts. The runtimes are side by side compatible.

2b)) Where can I go to specify the versions of the .DLLs for each application references on Window Sever 2003? I couldn't found anywhere in the property window of the IIS's web application virtual directory on the server. I assumed you meant doing the references of .DLLs versions is on the server under IIS! (I have tried to individually adding the DLLs to the references of each web application on my development machine and then complie/publish to production, I got error above, "Could not load file or assembly 'CrystalDecisions.ReportAppServer.CommLayer, Version=10.5.3700...").

- in a nut shell, what you have to do, is downgrade your app to use the 10.5 assemblies as described below. What you are doing in (2b) gives me the ebee jeebes. Downgrade your app as described here:

1) remove the CR version XI references from your project

2) delete the viewer from any forms it may be on

3) Save the app, close .NET

4) Uninstall CR XI

5) You may have to reinstall CR 10.5 by doing a custom install of CR 10.5 from the .NET 2008 install (actually, I'd recommend it now that I think about it...)

6) re-add the viewer to your form(s) from version 10.5 of Crystal Reports

7) The references to CR assemblies should be added automatically. Check on that.

😎 Compile the app

9) Distribute the CR runtime using the MSI for CR 10.5 (as per above)

Note: do the above only if your CR XI reports are not using any new features from CR XI.

If none of the above helps, I'd suggest obtaining a phone support incident so a technician can help you out. Phone support can be obtained here:

http://store.businessobjects.com/store/bobjamer/DisplayProductByTypePage&parentCategoryID=&categoryI...

Ludek

Edited by: Ludek Uher on May 22, 2009 7:31 AM

[Former Member]

Hi;

2a)) Will installing CRRedist2008_x86.msi overwrite the installed CrystalReports11_NET_EmbeddedInstall.msi files? Is there a way that I can specify a different location without causing any conflicts between these 2 runtime packages/.DLLs files?

- These two versions are designed to run side-by-side. So, just installing the CRRedist2008_x86.msi will be fine, nothing will be overwritten.

2b)) Where can I go to specify the versions of the .DLLs for each application references on Window Sever 2003? I couldn't found anywhere in the property window of the IIS's web application virtual directory on the server. I assumed you meant doing the references of .DLLs versions is on the server under IIS! (I have tried to individually adding the DLLs to the references of each web application on my development machine and then complie/publish to production, I got error above, "Could not load file or assembly 'CrystalDecisions.ReportAppServer.CommLayer, Version=10.5.3700...").

- The versions of the dlls is specified in the web.config for each application. The reason you are getting the error is that the CRRedist2008_x86.msi has not been installed.

To use the newer XI R2 reports in .NET 2008, you really should upgrade to Crystal Reports 2008. There may be problems trying to run newer reports in the older runtime version.

Best Regards,

Jonathan

[Former Member]

Hi, Iris;

Version XI R2 of Crystal Reports is not supported with VS.NET 2008. But, as you can see from the error, what the program is really looking for is version 10.5, which is the version of Crystal Reports that is bundled with .NET 2008.

You need to install the CR for .NET 2008 version on your server, which is the CRRedist2008_x86.msi file.

Best Regards,

Jonathan

[Former Member]

Thank SO SO much for your quick response. I sensed that the error is looking for CR version 10's assembly, but the thing is the report is design with CR 11 R2! Is it possible if I can force/add the CR 11's components to the web application's references individually? I tried but, it keeps showing that version 10 when I look at .DLL's property. Another problem I am trying to avoid is that we are still having some applications on production server using .NET 1.0 with CR11 runtime. PLEASE ADVISE!

Thanks a million.

Regards,

--Iris