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 -
A report will always be a part of a project or solution, so...
The first step is to open visual studio. If it opens to a start up page, you will see some things to choose from there - New Project, Open Project, and Recent. Are there any recent projects? If so, this would be a good place to start.
If VS doesn't open to a Start page, click File and look in Recent Projects & Solutions. Is anything displayed there. If so, open one to see if the report you are looking for is listed there.
We are hosted so all of our projects are under the Tessitura_Custom project. There is also a Recent files option under the File menu that may or may not display the report you are looking for.
The most important thing is, even if you open a solution, you aren't making any changes to the reports in them yet. They are just open, so you can safely look for the one you want to get the information from.
Once the solution/project is open, look in the solution explorer under reports to find the report you are interested in. Once you find it you can open it and look at the data set for the procedure name.
Good luck.
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.