Hello -
I've been asked to look at the code behind an old report that may need a rewrite. The report is deployed to our SSRS website. However, I need to open it in Visual Studio to find the procedure it's based on. I cannot however find the solution the report is saved under. I've gone to the SSRS website and checked all the Properties screens I can think to check but cannot find it.
Does anyone know a way to trace out the file location of a solution a report deployed to the SSRS page lives in? Or barring that how to open a deployed SSRS report in Visual Studio directly?
Thanks!
Richard, if you have access to the SSRS website, why not just download the report rdl and open it up in a solution/project that you create? From there you can look at the dataset to see the stored procedure being used.
Or alternatively, you could just open it via Report Manager, which is a free download.