VB Crystal Report, Change Server at Run Time

Change Server at Run Time

Author	Message
M #1 / 4	Change Server at Run Time Can you Change the server (SQL Server) of a report in CR8 at run-time? I have a bunch of reports created on one server that point to that server in the Location. When I move them to another server, I get a Server not yet connected error even though I use the SETLOGONINFO to set the server, username, database and password to the correct data. If I change the server in the report, it works fine. It is a huge inconvenience to keep changing it though as I use different servers for development, testing, production, etc.
Tue, 02 Mar 2004 10:35:32 GMT

Jack Carpente #2 / 4	Change Server at Run Time This thread from our forum might help... http://www.hammerman.com/dcforum/DCForumID1/162.html#1 good luck Jack Carpenter, Senior Consultant Hammerman Associates, Inc. Phone: 410.641.9469/800.783.2269 Fax: 410.641.1489 "Information Your Way Quote: > Can you Change the server (SQL Server) of a report in CR8 at run-time? > I have a bunch of reports created on one server that point to that > server in the Location. When I move them to another server, I get a > Server not yet connected error even though I use the SETLOGONINFO to > set the server, username, database and password to the correct data. > If I change the server in the report, it works fine. It is a huge > inconvenience to keep changing it though as I use different servers > for development, testing, production, etc.
Tue, 02 Mar 2004 21:37:22 GMT

M #3 / 4	Change Server at Run Time I do exactly that, but it doesn't work. If the server that the report was created with is not accessible, an error is given even after changing to the server you want to use with SetLogonInfo. Quote: > This thread from our forum might help... > http://www.hammerman.com/dcforum/DCForumID1/162.html#1 > good luck > Jack Carpenter, Senior Consultant > Hammerman Associates, Inc. > Phone: 410.641.9469/800.783.2269 > Fax: 410.641.1489 > "Information Your Way > > Can you Change the server (SQL Server) of a report in CR8 at run-time? > > I have a bunch of reports created on one server that point to that > > server in the Location. When I move them to another server, I get a > > Server not yet connected error even though I use the SETLOGONINFO to > > set the server, username, database and password to the correct data. > > If I change the server in the report, it works fine. It is a huge > > inconvenience to keep changing it though as I use different servers > > for development, testing, production, etc.
Wed, 03 Mar 2004 03:47:13 GMT

Jack Carpente #4 / 4	Change Server at Run Time Have you tried playing with the SetDAtaSource and SetTableLocation subs? Quote: > I do exactly that, but it doesn't work. If the server that the report > was created with is not accessible, an error is given even after > changing to the server you want to use with SetLogonInfo. Quote: > > This thread from our forum might help... > > http://www.hammerman.com/dcforum/DCForumID1/162.html#1 > > good luck > > Jack Carpenter, Senior Consultant > > Hammerman Associates, Inc. > > Phone: 410.641.9469/800.783.2269 > > Fax: 410.641.1489 > > "Information Your Way > > > Can you Change the server (SQL Server) of a report in CR8 at run-time? > > > I have a bunch of reports created on one server that point to that > > > server in the Location. When I move them to another server, I get a > > > Server not yet connected error even though I use the SETLOGONINFO to > > > set the server, username, database and password to the correct data. > > > If I change the server in the report, it works fine. It is a huge > > > inconvenience to keep changing it though as I use different servers > > > for development, testing, production, etc.
Sat, 06 Mar 2004 21:51:36 GMT

Page 1 of 1

[ 4 post ]