Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to Do Right - Winform - Remote Servers
Message
General information
Forum:
ASP.NET
Category:
Reporting
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01145776
Message ID:
01145792
Views:
19
This message has been marked as the solution to the initial question of the thread.
Hi, Kirk

First, when you instantiate the report object, you need to set the servername. Here's some code, since you posted this under VB.NET (I pulled this from an old post, i haven't tested it, but it should either work or be close)
Dim logOnInfo As New CrystalDecisions.Shared.TableLogOnInfo()
Dim i As Integer
For i = 0 To report.Database.Tables.Count - 1                  <== Error on report
   ' Set the connection information for current table.
   logOnInfo.ConnectionInfo.ServerName = "server"
   logOnInfo.ConnectionInfo.DatabaseName = "DbName"
   logOnInfo.ConnectionInfo.UserID = "UserID"
   logOnInfo.ConnectionInfo.Password = "PW"
   report.Database.Tables.Item(i).ApplyLogOnInfo(logOnInfo)   <==Error on report
next
Second, you might want to consider designing your reports against either typed datsets or schema definitions.

Kevin
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform