Display Data Source name in Report Header/Footer

Good day,

I apologize if this question has been asked before, but is there any way to display the name of the Data Source in the body of a report.

One solution to fetch the server my data is coming from is to create a new dataset with the query

SELECT@@SERVERNAMEas [Server Name]

but it would be nice to know the Data Source being used as well. Transparency is a big deal and this would be nice.

Thanks in advance,

Calvin

[636 byte] By [CalvinThomas] at [2007-12-19]