sql server reporting services: display of dynamically generated queries -- sql server reporting services

display of dynamically generated queries

cmueller NO[at]SPAM mcomt.de
9/25/2004 3:24:03 AM

sql server reporting services:

I wonder, if there is a way to display the dynamically generated
sqlstatement in a report.
I'm doing a lot with dynamically created queries and sometimes it'd be
very handy, if i could see the finally generated sqlstatement. I tried
the profiler, which works, and I want it nicer !

Thanks for any suggestions

Re: display of dynamically generated queries

Robert Bruckner [MSFT]
9/28/2004 6:38:13 PM

The closest you can get today, is to add a textbox to the report and
copy&paste the expression you use for the query into the textbox. Therefore,
the textbox will evaluate to the same value as the query.

We have already a tracking item for this (exposing the commandtext in the
ReportObjectModel) and it will be evaluated for inclusion in a future
release. Thanks for the suggestion.

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

[quoted text, click to view]