We have here an application (not written by me) and I would like to know what SP or View a certain RDL gets its record from, I have access to the database and the report server but I don't know how to determine the source of the report.
Printable View
We have here an application (not written by me) and I would like to know what SP or View a certain RDL gets its record from, I have access to the database and the report server but I don't know how to determine the source of the report.
Run a SQL Server PROFILE and monitor your sql statements. Navigate to the page/form where you expect to have that SP to run, check back in the profiler which SP was ran.