display of dynamically generated queries

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
ChrisThe 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.
"chrisM" <cmueller@.mcomt.de> wrote in message
news:545ffea8.0409250224.614445eb@.posting.google.com...
> 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
> Chris