Member Avatar for jkvsos

hello i am developing asp.net+sql server+crystal report with vb code
i need a help to change report connection change from my vb code
please help me....

  • 2 Contributors
  • 1 Reply
  • 74 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Kusno
Member Avatar for Kusno

Hi jkvsos,
Try this one :

Try
            Dim Table As CrystalDecisions.CrystalReports.Engine.Table
            For Each Table In Crs.ReportDocument.Database.Tables
                Dim Logon As CrystalDecisions.Shared.TableLogOnInfo
                Logon = Table.LogOnInfo
                Logon.ConnectionInfo.ServerName = ConfigurationManager.AppSettings("Server").Trim
                Logon.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings("Database").Trim
                Logon.ConnectionInfo.Password = ConfigurationManager.AppSettings("Password").Trim
                Logon.ConnectionInfo.UserID = ConfigurationManager.AppSettings("UID").Trim
                Table.ApplyLogOnInfo(Logon)
            Next
        Catch ex As Exception
        
        End Try
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.