Guest User

Untitled

a guest
Mar 18th, 2018
96
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. Dim RptDocument As New CrystalDecisions.CrystalReports.Engine.ReportDocument
  2.  
  3. RptDocument.Load("c:Informe.rpt", CrystalDecisions.Shared.OpenReportMethod.OpenReportByDefault)
  4.  
  5. RptDocument.DataSourceConnections.Clear()
  6.  
  7. Dim CTableLogInfo As CrystalDecisions.Shared.TableLogOnInfo
  8. Dim ConnInfo As CrystalDecisions.Shared.ConnectionInfo = New CrystalDecisions.Shared.ConnectionInfo()
  9.  
  10. ConnInfo.Type = CrystalDecisions.Shared.ConnectionInfoType.CRQE
  11. ConnInfo.ServerName = String.Empty
  12. ConnInfo.DatabaseName = "c:dbConPasswrod.mdb"
  13. ConnInfo.UserID = "Admin"
  14. ConnInfo.Password = "5354"
  15. ConnInfo.AllowCustomConnection = False
  16. ConnInfo.IntegratedSecurity = False
  17.  
  18. For Each CTable As CrystalDecisions.CrystalReports.Engine.Table In RptDocument.Database.Tables
  19. CTable.LogOnInfo.ConnectionInfo = ConnInfo
  20. CTableLogInfo = CTable.LogOnInfo
  21. CTableLogInfo.ReportName = "Informe.rpt"
  22. CTableLogInfo.TableName = CTable.Name
  23. CTable.ApplyLogOnInfo(CTableLogInfo)
  24. Next
  25.  
  26. CrystalReportViewer1.ReportSource = RptDocument
  27. CrystalReportViewer1.RefreshReport()
  28.  
  29. RptDocument.DataSourceConnections.Item(0).SetLogon("admin", "xx")
Add Comment
Please, Sign In to add comment