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 - 2012-08-01 : 11:48:10
|
| In a SSRS 2008 R2 standard edition report, I can see where a report is scheduled to run and I can see that it got executed. However, I do not know how to find the file directory location of where the report is stored in the file directory structure. In addition, I do not know how to tell what sql (stored procedure) was executed when the SSRS report was generated. Thus can you tell me how to verify where the SSRS 2008 r2 report is stored in the file directory and how to tell what stored procedure is executed for the SSRS 2008 r2 report that was generater on the report server? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-01 : 12:14:17
|
| you should be looking up in report manager for that. type url for report manager and you can see reports organised into folders inside it.for getting query behind download report and open it in bids------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSRS 2008 file directory location