SQL Server Name

[RKLawton]

Is there a way to print the server name from where the report is getting the data from?____Tried the following expressions:__a) SQLEXP( "host_name()" )__b) SQLEXP( "SERVERPROPERTY( ^SERVERNAME^ )" )__*R&R will not even preview the report having the above calculated field expression on the report.

[kfleming]

I tried a calc using SQLEXP("host_name()")and got no error but no value. Yet when I use Query Analyzer, the same expression does bring back the name of the server.____It is as if it is bringing back a zero length result...__I am not sure that there is any alternative available that would get you what you want.____Kathleen__R&R Support__