I have about the same problem. I try to make my first report but when I try to open it in the browser I get the message Logon failed. I have MS SQL Server, VS.NET 2002 with SP2 and Windows XP. During the development I use Integrated security. CrystalDecisions has an article (c2010371), not for integrated security, which suggested the following solution that didn't solve my problem:
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim crtableLogoninfos As New TableLogOnInfos()
Dim crtableLogoninfo As New TableLogOnInfo()
Dim crConnectionInfo As New ConnectionInfo()
Dim CrTables As Tables
Dim CrTable As Table
Dim TableCounter As Integer
Dim crReportDocument As New report1()
With crConnectionInfo
.ServerName = "severname"
.UserID = "userid"
.Password = "password"
.DatabaseName = "databasename"
End With
CrTables = crReportDocument.Database.Tables
For Each CrTable In CrTables
crtableLogoninfo = CrTable.LogOnInfo
crtableLogoninfo.ConnectionInfo = crConnectionInfo
CrTable.ApplyLogOnInfo(CrTable.LogOnInfo)
Next
CrystalReportViewer1.ReportSource = crReportDocument
End Sub
Private Sub CrystalReportViewer1_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Init
End Sub
Just now I have no more ideas so if anyone could help me I would :)
Eje
|
