Monday, December 03, 2012 8:24 PM
How do we see the query that actually SSRS passes to database to execute? Is Debugging possible for SSRS?
Monday, December 03, 2012 8:33 PM
If the target RDBMS is SQL Server, then you can use the SQL Server Profiler to trace queries.
Olaf HelperBlog Xing
- Proposed As Answer by Naomi NMicrosoft Community Contributor Wednesday, December 05, 2012 3:08 AM
Monday, December 03, 2012 8:43 PMSorry its oracle database
Wednesday, December 05, 2012 2:37 AMModerator
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:
If you have any questions, please feel free to ask.
TechNet Community Support