frmPortafolio.vb 1.1 KB

123456789101112131415161718192021222324252627282930313233343536
  1. Imports CrystalDecisions.CrystalReports.Engine
  2. Imports CrystalDecisions.Shared
  3. Public Class frmPortafolio
  4. Private Sub CrystalReportViewer1_Load(sender As Object, e As EventArgs) Handles CrystalReportViewer1.Load
  5. Dim crSubDB As Database
  6. Dim crTables As Tables
  7. Dim cInfo = New ConnectionInfo()
  8. cInfo.ServerName = My.Settings.ServidorSQL
  9. cInfo.UserID = My.Settings.UsuarioSQL
  10. cInfo.Password = My.Settings.ClaveSQL
  11. cInfo.DatabaseName = My.Settings.BaseDeDatos
  12. Dim oRPT = New rptPortafolio
  13. crSubDB = oRPT.Database
  14. crTables = crSubDB.Tables
  15. Dim crTableLogOnInfo As TableLogOnInfo
  16. For Each crTable In crTables
  17. crTableLogOnInfo = crTable.LogOnInfo
  18. crTableLogOnInfo.ConnectionInfo = cInfo
  19. crTable.ApplyLogOnInfo(crTableLogOnInfo)
  20. Next
  21. CrystalReportViewer1.ReportSource = oRPT
  22. 'CrystalReportViewer1.Zoom(100)
  23. End Sub
  24. Private Sub frmPortafolio_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  25. End Sub
  26. End Class