Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-02-05 : 15:23:51
|
| I am working with a visual studio ide for SSRS report 2008 r2. I would like to see what stored procdure is executed for the report. However while I am in visual studio, I do not know how find the stored procedure. Thus can you tell me what to click on so that I can find the stored procedure behind a report? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-02-05 : 16:35:00
|
| In Visual Studio, in the report data window, look for data sets of the report, right click and select properties. There may also be shared datasets which you will find in the solution explorer. Open those as well and look for the queries.You can also search through the rdl files - look for <CommandText> nodes. |
 |
|
|
|
|
|
find stpred procedure for ssrs 2008 r2 report