Page 1 of 1
SQL Server Name
Posted: Fri May 07, 2004 10:06 am
by 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.
=> RE: SQL Server Name
Posted: Mon May 10, 2004 5:10 pm
by 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__