Post reply

SSRS 2008 file directory location

  • August 1, 2012 at 9:50 am

    #278772

    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?

  • August 1, 2012 at 10:50 am

    #1520403

    Hi Wendy,

    Do you mean the path the file is stored at from a Windows file Share subscription? If so, check the Subscriptions table in the ReportServer database.

    If you mean from a normal execution e.g. to create a snapshot, then the report data is held in the ReportServer database in binary format.

    Similarly, the Content field in the Catalog table holds the report definition (.rdl) file in binary format. The SQL/proc that's executed is in there somewhere.

    Thanks

    Gaz

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply