crystal report not show and failed to connect server , sql India
  • 12 years ago
    hi i have one crystal report in when i connect to local host and run on same server its run but, when i run this report on different computer having servername different,it will not connect and show a window contains they want some information like username,password but i wanna connect it as integrated security i am using this code Dim q As String q = "select kt_studid,kt_accno,kt_issue,kt_rec,kt_title from kt_issue_stud" ktda = New SqlDataAdapter(q, ktcn) ktda.Fill(ktds, "abc") cr2.SetDataSource(ktds.Tables("abc")) rviewer.CrystalReportViewer1.ReportSource = cr2 rviewer.CrystalReportViewer1.RefreshReport() ktds.Tables.Clear() cr2.Refresh() rviewer.Show() Dim myTextObjectName As CrystalDecisions.CrystalReports.Engine.TextObject myTextObjectName = cr2.Section2.ReportObjects.Item("text25") myTextObjectName.Text = "Criteria" + " (ALL) :" rviewer.CrystalReportViewer1.ReportSource = cr2 Dim myTextObjectName1 As CrystalDecisions.CrystalReports.Engine.TextObject myTextObjectName1 = cr2.Section2.ReportObjects.Item("text26") myTextObjectName1.Text = "ALL" rviewer.CrystalReportViewer1.ReportSource = cr2

Post a reply

No one has replied yet! Why not be the first?

Sign in or Join us (it's free).


Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“The difference between theory and practice is smaller in theory than in practice.”