Displaying Datasource in Crystal

[Lil Ms Squirrel]

Is there any way to dynamically display on a printed Crystal Report the name of the (SQL Server) database that the report is being generated from?

I have a lot of reports that frequently get pointed at different test and production databases and I want a simple way for my users to identify where the data has come from.

(Preferably something simpler than passing the database name to the stored proc and then returning it as part of the dataset for the report)

[kulitag]

how do you connect the database to your report, by code or just linking directly the report to the database

[Lil Ms Squirrel]

In this case it's direct, but sometimes I might want to implement it through code.