Capturing Server Information

[TJBernard]

Thank you all for your help in advance, because this is a doozy.

I am opening Crystal Reports from an MS Access Database, and everything is opening fine, good deal. Now the plan is to move the database to a web cluster, so that the Crystal Reports will be stored on up to 3 different servers, and I cannot use the physical path to the Reports, due to the web-cluster.

My plan is to capture the correct server name in a variable, and then through code set up the correct server path based on the variable value. This should do the trick.

My question is, does anyone know how to capture server information? I was thinking alont the lines of this code that captures the User's User Name:

Environ("Home")

Is there an arguement for the Environ fuction that will capture a server name?

Thank you again for your help,

T.J.

 

[David R]

Use this in the debug window, or write a function to cycle through them:
? Environ, where n is from 0 to (I think) 40. Server name is in there somewhere.

 

[TJBernard]

David,

Thank you very much, it has helped me tremendously.

T.J.