Query from SSRS to SSMS

• Minnu

  SSCertifiable

  Points: 6451

  More actions

  July 31, 2013 at 4:29 am

  #297031

  Hi Team,

  We have a Report (SSRS) with select query, when we generate the report, Database is hanging,

  how to find the query which is executed inside the report.

  is there any possible way / query to find the query which is executed thru Report (SSRS).

  Please suggest..

• VSSGeorge

  SSCrazy Eights

  Points: 8146

  More actions

  July 31, 2013 at 7:11 am

  #1637364

  Open the report in report designer tool (i.e.. Visual Studio) and look for datasets created inside the report.

  If you right click the dataset>> dataset properties, you can see the query or the stored procedure name.

  If you are not seeing the dataset, proceed this way, VIEW>> Report Data in Visual Studio

• saxena200

  Ten Centuries

  Points: 1156

  More actions

  July 31, 2013 at 7:24 am

  #1637373

  You can see the exact query in SQL Server Profiler, create a new trace and start it before rendering the report

  Open SQL Server Profiller - All programs -> MS SQL Server 2008 R2 -> Performance Tools

  Start a new trace -> Go to event selection -> Check Tsql events -> run the trace

  render the report, u will get the query.