Printing Server name/database on page footer

[dyan24]

How do i print on the footer page the server name & database name of my report?

e.g.
Environment: Devt/db_name

 

[vidru]

Assuming you're using SQL Server, and you're not using a stored procedure to get your data, create a SQL Expression field with this text:
[tt]
@@servername + '/'+ db_name()
[/tt]
If you are using a stored procedure, you might have to do this in an unlinked subreport, or return it from the procedure as part of your result set.

-dave

 

[synapsevampire]

You might be able to create a SQL Expression to do this, however you'll need to learn what version of Crystal you intend to use and that it supports SQL Expressions, and what type of database you're using and the syntax for returning this information from the database as Crystal doesn't have this functionality.

-k

 

[dyan24]

I am using Crystal Report v10 and SQL Server.

Unfortunately i have some reports that are using SP. Also, we want to add this in our report template. Is this possible?

Thanks k & dave!