Loading

SQL Server REporting Servoces .rdlc excel export

Scott Lackey

16y3.3k

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...

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sam Hobbs16y ago

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();