K
KK
In crystal report I am getting this error.
CrystalDecisions.CrystalReports.Engine : Logon failed.
at .K(String , EngineExceptionErrorID ) at .F
(Int16 , Int32 ) at .E(Int16 ) at
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export
(ExportRequestContext reqContext) at
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export
*****Note******
In order to resolve this everybody is recommending to put
security credentials in the code and I did so, still I
have the problem. Looks like my IIS security is giving
trouble. Can any body tell me what I need to cahnge.
Here is the code I am using.
Dim crDoc As ReportDocument
Dim crExp As ExportOptions
Dim crDiskFileDestinationOptions As
DiskFileDestinationOptions
Dim crPath As String
Try
Dim sValue As String
Dim s As String
crDoc = New ReportDocument()
crDoc.Load(Server.MapPath("Mypt.rpt"))
'*****************
Dim crLogonInfo As
CrystalDecisions.Shared.TableLogOnInfo
crLogonInfo = crDoc.Database.Tables
(0).LogOnInfo
crLogonInfo.ConnectionInfo.ServerName
= "MyServer"
crLogonInfo.ConnectionInfo.UserID = "MyId"
crLogonInfo.ConnectionInfo.Password = "welcome"
crLogonInfo.ConnectionInfo.DatabaseName
= "TestDB"
crDoc.Database.Tables(0).ApplyLogOnInfo
(crLogonInfo)
'**********************
crPath = Request.PhysicalApplicationPath
crDiskFileDestinationOptions = New
DiskFileDestinationOptions()
crExp = crDoc.ExportOptions
crDiskFileDestinationOptions.DiskFileName =
crPath + "InvlovedParty.rpt.pdf"
With crDoc.ExportOptions
.ExportDestinationType =
ExportDestinationType.DiskFile
.ExportFormatType =
ExportFormatType.PortableDocFormat
.DestinationOptions =
crDiskFileDestinationOptions
End With
'crDoc.Refresh()
crDoc.Export()
Response.Write("Report File Exported")
Response.Redirect("InvlovedParty.rpt.pdf")
Catch ex As Exception
Response.Write(ex.Source & " : " & ex.Message)
Response.Write("<BR>")
Response.Write(ex.StackTrace)
CrystalDecisions.CrystalReports.Engine : Logon failed.
at .K(String , EngineExceptionErrorID ) at .F
(Int16 , Int32 ) at .E(Int16 ) at
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export
(ExportRequestContext reqContext) at
CrystalDecisions.CrystalReports.Engine.FormatEngine.Export
*****Note******
In order to resolve this everybody is recommending to put
security credentials in the code and I did so, still I
have the problem. Looks like my IIS security is giving
trouble. Can any body tell me what I need to cahnge.
Here is the code I am using.
Dim crDoc As ReportDocument
Dim crExp As ExportOptions
Dim crDiskFileDestinationOptions As
DiskFileDestinationOptions
Dim crPath As String
Try
Dim sValue As String
Dim s As String
crDoc = New ReportDocument()
crDoc.Load(Server.MapPath("Mypt.rpt"))
'*****************
Dim crLogonInfo As
CrystalDecisions.Shared.TableLogOnInfo
crLogonInfo = crDoc.Database.Tables
(0).LogOnInfo
crLogonInfo.ConnectionInfo.ServerName
= "MyServer"
crLogonInfo.ConnectionInfo.UserID = "MyId"
crLogonInfo.ConnectionInfo.Password = "welcome"
crLogonInfo.ConnectionInfo.DatabaseName
= "TestDB"
crDoc.Database.Tables(0).ApplyLogOnInfo
(crLogonInfo)
'**********************
crPath = Request.PhysicalApplicationPath
crDiskFileDestinationOptions = New
DiskFileDestinationOptions()
crExp = crDoc.ExportOptions
crDiskFileDestinationOptions.DiskFileName =
crPath + "InvlovedParty.rpt.pdf"
With crDoc.ExportOptions
.ExportDestinationType =
ExportDestinationType.DiskFile
.ExportFormatType =
ExportFormatType.PortableDocFormat
.DestinationOptions =
crDiskFileDestinationOptions
End With
'crDoc.Refresh()
crDoc.Export()
Response.Write("Report File Exported")
Response.Redirect("InvlovedParty.rpt.pdf")
Catch ex As Exception
Response.Write(ex.Source & " : " & ex.Message)
Response.Write("<BR>")
Response.Write(ex.StackTrace)