Debugging SQL queries in SSRS

Question

Hi,

How do we see the query that actually SSRS passes to database to execute? Is Debugging possible for SSRS?

Thanks

Serena

Answer 1

Hello Serena,

If the target RDBMS is SQL Server, then you can use the SQL Server Profiler to trace queries.

---

Olaf Helper

Blog Xing

Answer 2

Sorry its oracle database

Answer 3

Hi Serena,

In SQL Server Reporting Services (SSRS) there is no real way of setting break points and such to step through the program. It's just a report, it should either compile or error, and it will either return data or not. So I am afraid we cannot debug SQL queries in SSRS. If you want debug queries, you can use Oracle PL/SQL debugger to debug it, for more information about how to use it, please see:
http://www.youtube.com/watch?v=Y3XzcPvd0tI
http://www.aquafold.com/aquadatastudio/oracle_sql_debugger.html

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support