title: Creating a Custom Export to Excel for ReportViewer (rdlc)
body: <p>I'm interested in creating a custom Export to Excel option for my Report in ReportViewer. This is mostly because I want pdf disalbed and I did that via:</p>
  
  <pre><code> ReportViewer1.ShowExportControls = false;
  </code></pre>
  
  <p>Since there is no way to disable any specific export functionality (e.g. pdf but not excel) in ReportViewer. Here's my (slightly) modified code below. Ideally I would like something similar to the previous Export options where I can save the file to whatever location I want.</p>
  
  <p>EDIT: The code works but how would I need to modify the Filestream so that instead of having the file get saved automatically I can prompt the user so that they can save to whichever location they want?</p>
  
  <pre><code>protected void btnExportExcel_Click(object sender, EventArgs e)
  {
      Warning[] warnings;
      string[] streamids;
      string mimeType;
      string encoding;
      string extension;
  
      byte[] bytes = ReportViewer1.LocalReport.Render(
         "Excel", null, out mimeType, out encoding,
          out extension,
         out streamids, out warnings);
  
      FileStream fs = new FileStream(@"c:\output.xls",
         FileMode.Create);
      fs.Write(bytes, 0, bytes.Length);
      fs.Close();
  
  }
  </code></pre>