sql server - How to get the name of the DataSource referenced by my shared DataSet? -
i display name of data source used in report, way identify origin of data.
i know can display name of embedded datasource :
=datasource("name").datasourcereferencestring
however report not embed datasource using shared datasets.
any ideas ? "doing wrong" ?
edit : answers far involve using datasources collection. thing is... report not reference data source whatsoever. reference shared dataset, references data source. approach allows me change data source of reports editing shared dataset. i'm open better ideas.
this might u .it represents collection of data sources referenced within body of report
datasources("name").type
for detail explanation can go through link using global collections in expressions (reporting services)
Comments
Post a Comment