This question is exactly what I want, unfortunately my knowledge of MSSQL is too basic to even understand the answer.
The accepted answer just said "Or you can look at the report in design view and go to properties to see the query that is feeding it". For me this just triggers more questions.
1. "Design view" in which software?
As I look through the installed programs on the database host, I don't see anything leaping out, like Crystal Reports, to view the contents of a .rpt file. I can connect to the SQL Server from MSSQL Management Studio, but that doesn't seem to allow me to open the .rpt file. I have found some .log files on the host, and that is where I found the paths to the .rpt files. I have tried opening the .rpt files with Notepad, but that results in a lot of ASCII salad.
I can't even promise that it is Crystal Reports producing the reports. What I know is that our operator can click a button that says "Reports", configure some parameters for the report and then print it. My ultimate objective is to get the data of the report that gets produced in its own table. Of course that wouldn't even be necessary if I just knew where the data was stored and how to extract it.