show database server name in crystal report

Question

Anybody know how to show a database server name on crystal report. I am using crystal report X, store procedure as data source to crystal report.

If you use view then you can use SQL expression field to display server name using, select SERVERPROPERTY('servername') select @@SERVERNAME

But how can we do it using stored procedure (as SQL Expression filed is not avialable in this datasource in crystal report).

Thanks in advance.

Buck Hicks Buck Hicks · Accepted Answer · 2013-06-05T13:03:27

If you are just trying to pass the Database Name through the stored procedure so that it is available in Crystal Reports you could do it by declaring the variable and adding it to the Select Query like this.

Alter PROCEDURE SelectSomeRecords 
AS
BEGIN
SET NOCOUNT ON;


Declare @DatabaseName varchar(25) 
Set @DatabaseName = (SELECT DB_NAME())


Select  top 10 LastName
        , FirstName 
        , @DatabaseName as DatabaseName
from    Customers

END
GO

This may be a hack way to do it but I haven't found a way to do it similar to the way you do with a SQL Expression.

show database server name in crystal report

3 Answers