title: How can I determine the Stored Proc used on an SSRS page?
body: <p>We have an SSRS Report Server (I don't know if the name "Report Sever" is peculiar to us or common to SQL Server report services (IOW, I don't know if we chose it, or Microsoft did)) that hosts various queries that users can run against our data.</p>
  
  <p>I need to find out which query is being run, probably which Stored Proc, for a given report that is available.</p>
  
  <p>I thought I could suss that out via the "View Source" from the page, but I see no "data source," nor the name of our connection, or such. In fact, I looked through the entire source and saw nothing helpful.</p>
  
  <p>The "View Report" button is:</p>
  
  <pre><code>&lt;td&gt;&lt;input type="submit" name="ReportViewerControl$ctl04$ctl00" value="View Report" id="ReportViewerControl_ctl04_ctl00" /&gt;
  </code></pre>
  
  <p>...and the only other reference to it is here:</p>
  
  <pre><code>Sys.Application.add_init(function() {
      $create(Microsoft.Reporting.WebFormsClient._PromptArea, {"CredentialsLinkId":"ReportViewerControl_ctl04_ctl01","ParameterIdList":["ReportViewerControl_ctl04_ctl03","ReportViewerControl_ctl04_ctl05","ReportViewerControl_ctl04_ctl07","ReportViewerControl_ctl04_ctl09"],"ParametersGridID":"ParametersGridReportViewerControl_ctl04","ReportViewerId":"ReportViewerControl","ViewReportButtonId":"ReportViewerControl_ctl04_ctl00"}, null, null, $get("ReportViewerControl_ctl04"));
  });
  </code></pre>
  
  <p>Is there a way, either from the "View Source" or otherwise, where I can coax out the SP used to generate the report?</p>
  
  <h2>UPDATE</h2>
  
  <p>Spurred on by Steve Mangiameli's comment, I see that I have the following in my Start menu:</p>
  
  <pre><code>MS SQL Server 2005
      SQL Server Business Intelligence Development Studio (BIDS)
  MS SQL Server 2008
      SQL Server Installation Center
  MS SQL Server 2012
      SQL Server Data Tools
  </code></pre>
  
  <p>I don't know which, of any, of these has value for me in this quest.</p>
  
  <h2>UPDATE 2</h2>
  
  <p>We do have a Visual Studio 2005 project named "Report Server" project with many .rdl files beneath the "Reports" folder. I thought this was a unique-to-us solution, but maybe not.</p>
  
  <p>Even if this <em>is</em> the "Report Server" mentioned, though, I still don't know <em>which</em> .rdl file is the one that drives the report I can generate via our online Report Viewer page.</p>
  
  <p>It would be nice if the report, when generated, had some reference to the name of the related .rdl file.</p>