ssrs - datasets tables

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.
more ▼

asked May 04, 2012 at 07:24 AM in Default

Mohan gravatar image

324 39 56 60

you will need to ask a specific question in order for anyone to be able to help you. If you have error messages that including them can help and certainly explain what you have already tried so we can see how to assist.
May 04, 2012 at 07:37 AM Fatherjack ♦♦
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first
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.
more ▼

answered May 07, 2012 at 02:21 PM

Stacia gravatar image


Welcome to the community @Stacia Misner
May 07, 2012 at 02:47 PM Blackhawk-17
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: May 04, 2012 at 07:24 AM

Seen: 564 times

Last Updated: May 07, 2012 at 02:47 PM