Crystal Report security issue

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,774
Messages
2,569,598
Members
45,160
Latest member
CollinStri
Top