locked
Find out which query is used in a report RRS feed

  • Question

  • User-1210839387 posted

    Using Report Builder 2.0

    There is an existing report that I need to change.  How do I find out and view the sql query that is currently being used for this report?

    Thanks

    MC

    Monday, June 20, 2011 8:18 AM

Answers

  • User-1210839387 posted

    I got it:  right click on the dataset attached to the report and look at "DataSet" Properties, that will show the query there.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 20, 2011 9:29 AM

All replies

  • User-125547262 posted

    If you do not have the report files, you can always run an  SQL profiler to find out what queries are run against your database when the reports are run

    http://sqlserverpedia.com/wiki/Using_SQL_Server_Profiler

    Monday, June 20, 2011 8:38 AM
  • User-1210839387 posted

    I don't have profiler installed. 

    I have access to all files for the report, which one do I look at to get the query used in the report?

    thanks

    Monday, June 20, 2011 8:59 AM
  • User-1210839387 posted

    I got it:  right click on the dataset attached to the report and look at "DataSet" Properties, that will show the query there.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, June 20, 2011 9:29 AM
  • User1471008070 posted

    Thank you for sharing your solutions and experience here. It will be very beneficial for other community members who have similar questions.

    Tuesday, June 21, 2011 1:22 AM