-
October 5th, 2013, 03:45 AM
#1
Crystal Report still show database login prompt after using .setdatabaselogon
hi im currently developing vb.net program using vs2012 and crystal report for vs service pack 6, i got issue when im try to load report when running the program it use odbc name as server name and keep showing database login prompt even after i set server name in code , the report run fine if i using report preview in ide.
this is the code i'm using to load the crystal report
Dim report As New ReportDocument()
report.Load(Application.StartupPath & "\Report\BACK OFFICE\lprinventory.rpt")
report.SetDatabaseLogon("sa", "424378", "LAPTOP", "COZY")
CrystalReportViewer1.ReportSource = report
Thanks
Surya Halim
Sorry for bad english
-
October 5th, 2013, 08:41 AM
#2
Re: Crystal Report still show database login prompt after using .setdatabaselogon
I use the next code
Code:
'Declarations
Public CRReport As CrystalDecisions.CrystalReports.Engine.ReportDocument
Public CRTable As CrystalDecisions.CrystalReports.Engine.Table
Public CRTLI As CrystalDecisions.Shared.TableLogOnInfo
'some procedure
CRReport = New CrystalDecisions.CrystalReports.Engine.ReportDocument
CRReport.Load(GRutaRpts & "MyReport.rpt", CrystalDecisions.Shared.OpenReportMethod.OpenReportByTempCopy)
For Each Module1.CRTable In CRReport.Database.Tables
CRTLI = CRTable.LogOnInfo
With CRTLI.ConnectionInfo
.ServerName = "MyDSNName"
.UserID = "MyUserName"
.Password = "MyPassword"
.DatabaseName = "MyDBName"
End With
CRTable.ApplyLogOnInfo(CRTLI)
Next CRTable
JG
... If your problem is fixed don't forget to mark your threads as resolved using the Thread Tools menu ...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|