Hi, I asked this Q before. I need to set the SQL ServerName at run-time for my reports. We have the same database on different servers. I created one report for them all. However the problem is that the CRViewer.dll (CR8) has a problem changing the servername using: Report.Database.Logonserver "p2ssql.dll","SERVERA","DBASENAME","Username","Password"
Does any1 have a different solution?
Thanks.
Vincent
Wed, 10 Sep 2003 10:55:54 GMT
Dimitris Assimakopoulo #2 / 3
Repost: changing server name at run-time
Vincent,
use this instead...
For i = 1 To Report.Database.Tables.Count Set CRTable = Report.Database.Tables.Item(i) CRTable.SetLogOnInfo "SERVER", "DATABASE", "UID", "PWD" Next i
D.-
PS: if your report contains subreports, you will have to open them and execute the above loop on their tables as well.
Quote:
> Hi, I asked this Q before. I need to set the SQL ServerName at run-time for > my reports. We have the same database on different servers. I created one > report for them all. However the problem is that the CRViewer.dll (CR8) has > a problem changing the servername using: > Report.Database.Logonserver > "p2ssql.dll","SERVERA","DBASENAME","Username","Password"
> Does any1 have a different solution?
> Thanks.
> Vincent
Wed, 10 Sep 2003 22:08:30 GMT
Mark Wilde #3 / 3
Repost: changing server name at run-time
Quote:
> Vincent,
> For i = 1 To Report.Database.Tables.Count > Set CRTable = Report.Database.Tables.Item(i) > CRTable.SetLogOnInfo "SERVER", "DATABASE", "UID", "PWD" > Next i
A slightly cleaner syntax is
for each table in Report.Database.Tables ' ... next
Repost: changing server name at run-time