Search code examples
sqlreporting-servicesdatasourcessrs-2008-r2sqldatasource

Displaying the data source in SSRS


How do I return and display the data source in SSRS?

I've got multiple data sources in the report in addition to Live vs. Test systems. How do I output/display a string with the data source.


Solution

  • There's no built in function to get data source names in an expression.

    Interestingly, you can use an expression to define a connection string. So you could use that same expression elsewhere on the report.

    I was hoping there was a way to access them through Custom Code. The only approach I could find though is to query the Report Server database.