SQL Server REporting Servoces .rdlc excel export

Question

Hello All.
I have a .rdlc report created in Visual Studio and upon executing, I wish to have the user be able to export the resulting data to Excel. How would I go about doing this?
Thanks in advance...

Sam Hobbs · Answer

What I have has been adapted from a sample in the MSDN so check the MSDN for documentation and samples. I hope the following helps. bytes = Report.LocalReport.Render(Excel null out mimeType out encoding out extension out streamids out warnings); fs = new FileStream(SaveReportDialog.FileName FileMode.Create); fs.Write(bytes 0 bytes.Length); fs.Flush(); fs.Close();