Search code examples
visual-studiot-sqlreporting-servicesssrs-2012

Debug query while executing in Preview Mode SSRS

My goal is to view the query that gets executed against the server while in Preview Mode of reporting services.

Is there anyway to do this? Or another approach that I can take to debug the actual query that is being executed by my SSRS report?

I can attach the query text, however I'm more concerned that the parameters are being passed correctly to the query.

Solution

  • I would suggest to install ExpressProfiler

    This is what I used to check that parameters are being passed correctly or not. Try this!