We have 3 environments over here (Development, Test, Production),
When we create reports we always use the same name (eg. datasource1)
On the reporting services database we have created 3 different datasources (eg dsDev, dsTest,dsProd) witch point to their databases.
Now at the moment that we publish a report we use the sqlsrvmgt to link 1 of the above 3 datasources to the published report.
So far so good.
Now would we love to print the name of the used datasource on our report self.
That way we can see directly when a report is printed from witch database the data comes from.
but i can't find of a way to accomplisch that.
Is there someone over here that has the same issue or even better, a solution for it.
Any help would be verry appreciated.