on 12-19-2018 12:20 PM
The following code is running perfectly on the development computer but fails when I deploy on another computer. All computers are reading data from the same database (On the server) and all are running windows 10 64 bit
Dim da As New SqlClient.SqlDataAdapter(sqlTXT, cnSTR)
dt = New DataSet
da.Fill(dt, "MyTable")
da.Dispose()
Dim rpt As rptmyReport = New rptmyReport
Dim crConInfo As New ConnectionInfo
Dim crLogInfo As New TableLogOnInfo
With crConInfo
.ServerName = SvrString
.DatabaseName = "MyDatabase"
.UserID = SlID
.Password = sPW
End With
crLogInfo.ConnectionInfo = crConInfo
rpt.Database.Tables(0).ApplyLogOnInfo(crLogInfo)
rpt.SetDataSource(dt)
crv.ReportSource = rpt
crv.ShowCloseButton = True
crv.ShowGroupTreeButton = False
crv.Show()
I have installed SAP Crystal reports runtime for .NET framework 13.0.9.1312 x64 on all machines.
What is funny is that if I set the report setDataSource("MyTable") {"MyTable"} being a physical table the report runs perfectly on the deployment PC
Can someone help why crystal reports if failing when I try to print from a dynamic dataset but the same report works when I try to print from a physical table?
User | Count |
---|---|
90 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.