sql server reporting services: Getting query associated with a dataset -- sql server reporting services

You're in the

sql server reporting services

group:

Getting query associated with a dataset

billd
12/27/2004 11:39:02 AM

sql server reporting services:

Is it possible to get the post-processed query that is associated with a
dataset?

I need to see the SQL or MDX query that is produced *after* the IIF(), Code,
Parameters, etc. have been evaluated.

For example, immediatley after I create the report (via CreateSubscription)
I would like to see the database query that it will use for the report.

Thanks,
Bill

Re: Getting query associated with a dataset

Robert Bruckner [MSFT]
12/27/2004 7:23:52 PM

Not sure if this is what you are looking for, but in RS 2000 you could just
add a textbox in the report which contains exactly the same expression as
the dataset query. Running the report shows you the expression evaluation
result.

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Re: Getting query associated with a dataset

Daniel Williams
12/28/2004 8:25:18 AM

I also would be interested in seeing this. When I write ASP code, I usually
allow flags to be passed to the web page which forces queries and other
logging into to be output as comments in the web page. This really helps
the debugging process.
And right now I'm having terrible problems connecting to and querying an
AS400 data source, and this info would be very useful.

Daniel Williams

[quoted text, click to view]

Re: Getting query associated with a dataset

billd
12/28/2004 8:49:06 AM

Thanks. Clever idea.

What do you think the best way would be to get te contents of the textbox
back to the calling application? (I use the Render API call now to display
the report).

If I set the the textbox to "hidden" I do not get the textbox in the
returned HTML fragment.

Bill

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server reporting services group.

home · blog · groups

Questions? Comments? Contact the dn