I suggest you ...

Add a way to view the SQL generated in SSRS without having to go through the SQL Server Profiler

At the moment it is an absolute pain to see how SSRS is generating SQL without going through SQL Server Profiler.

This is particularly the case when you have a predicate such as '[ColumnName] in (@InParameter)' and the @InParameter is a multi-select list.

The Dataset Designers are a great help but do not help when trying to debug Reports at runtime.

What I propose is to include a Tab next to Design and Preview tabs that shows the TSQL that is generated as a result of the parameter selections.

Or as an alternative allow the TSQL to be sent to the output window as the report is executing.

6 votes
Vote
Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
You have left! (?) (thinking…)
Nathan Fisher shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

Thank you for your suggestion! While we aim to respond to every suggestion, we are closing older ones that don’t have enough votes so newer ones from you can move to the top. If this suggestion is still important to you, feel free to open it again.

0 comments

Sign in
(thinking…)
Sign in with: facebook google
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base