We are in the process of developing a report which is Report Queries, which should display all the datasets are used in the report and their command text and we are done that part. Apart from that we need to fetch the tables which are used in the datasets.
asked May 04, 2012 at 07:24 AM in Default
If I understand the question correctly, this is not really an SSRS problem but a query problem. Here is a post with some potential approaches: http://go4answers.webhost4life.com/Example/sql-extract-table-names-sql-query-71953.aspx.
answered May 07, 2012 at 02:21 PM