VB.NET - crystal report failed in xp version - Asked By Rahul Kumar on 13-Jun-12 05:25 AM

hii
I have found a problem of the connection. Actually i have called a crystal report in my code and it works fine on my PC whose operating syatem is window7 and when i run the same exe in xp version then it gives me an connection pop up window in which database field is blank and when i click on ok then it gives me an error logon failed.

my code is as follows :

Dim cryRpt As New ReportDocument

cryRpt.Load(MainModule.bundlepath)


Dim crtableLogoninfos As New TableLogOnInfos()

Dim crtableLogoninfo As New TableLogOnInfo()

Dim crConnectionInfo As New ConnectionInfo()

Dim CrTables As Tables

Dim myParameterFields As New ParameterFields

Dim myParameterField As New ParameterField

Dim myDiscreteValue1 As New ParameterDiscreteValue

myParameterField.ParameterFieldName =

"style"

myDiscreteValue1.Value = MainModule.bundlestyle

myParameterField.CurrentValues.Add(myDiscreteValue1)

myParameterFields.Add(myParameterField)

CrystalReportViewer1.ParameterFieldInfo = myParameterFields

crConnectionInfo.ServerName =

"192.168.100.52"

crConnectionInfo.DatabaseName =

"vg2012may06"

crConnectionInfo.UserID =

"sa"

crConnectionInfo.Password =

"ocltest"

CrTables = cryRpt.Database.Tables

For Each CrTable As CrystalDecisions.CrystalReports.Engine.Table In CrTables

crtableLogoninfo = CrTable.LogOnInfo

crtableLogoninfo.ConnectionInfo = crConnectionInfo

CrTable.ApplyLogOnInfo(crtableLogoninfo)

Next

CrystalReportViewer1.ReportSource = cryRpt

CrystalReportViewer1.Visible =

True

so please help in recoverin the following problem


kalpana aparnathi replied to Rahul Kumar on 13-Jun-12 06:51 AM
hi,

This is because you have not installed the crystal report runtime on the machine where you are testing your application. Here are the links where you can download the runtime:You can get the installer from the below locations both for 32-bit and 64-bit machines:


32 bit:

http://resources.businessobjects.com/support/downloads/redistributables/vs_2008/redist/x86/CRRedist2008_x86.msi

64 bit:

http://resources.businessobjects.com/support/downloads/redistributables/vs_2008/redist/x64/CRRedist2008_x64.msi

Regards,
Rahul Kumar replied to kalpana aparnathi on 13-Jun-12 08:54 AM
hii kalpana

I have tried the same but then also it gives me the same problem. actually in the login popup it is not displaying the database name
Jitendra Faye replied to Rahul Kumar on 15-Jun-12 01:25 AM

I believe you are not the only one who has problems when trying to deploy Crystal Report for VS 2010. Based on the error message you had, have you checked:

1. Please make sure you just have one CR version installed on your system. If you do have other CR version installed, consider to uninstall it so that your application is not "confused" about the CR version.


2. You need to make sure you download the correct CR version. Since you are using VS 2010, you need to refer to http:// downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_64bit_13_0_1.zip (for 64 bit machine) or http:// downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_redist_install_32bit_13_0_1.zip (for 32 bit machine). These two are the redistributable packages. You can download full package from the below link as well via http:// downloads.businessobjects.com/akdlm/cr4vs2010/CRforVS_13_0_1.exe


3. Make sure you setup FULL TRUST permission on your root folder

4. The LOCAL SERVICE permission must be setup on your application pool

5. Make sure the aspnet_client folder exists on your root folder.

If you can make sure all the 5 points above, your Crystal Report should work without any fuss.

Another important thing to not down here is that if you host your Crystal Report with a shared host, you need to check it with them of whether they really support Crystal Report. If you still have problems, you can switch to http://www.asphostcentral.com/, who provides Crystal Report support.