Last post Jun 21, 2011 01:22 AM by You-Hu Fu
Jun 20, 2011 08:18 AM|MyronCope|LINK
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?
Jun 20, 2011 08:38 AM|Jeev|LINK
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
Jun 20, 2011 08:59 AM|MyronCope|LINK
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?
Jun 20, 2011 09:29 AM|MyronCope|LINK
I got it: right click on the dataset attached to the report and look at "DataSet" Properties, that will show the query there.
Jun 21, 2011 01:22 AM|You-Hu Fu|LINK
Thank you for sharing your solutions and experience here. It will be very beneficial for other community members who have similar questions.