Send SQL Report in E mail attachment using C# and ASP.NET

Question

I am trying to send report from sql reportserver 2008 as e mail attachment using ASP.NET and C#, Till now I learned how to Get report as PDF in my code , Now I wanna combine line of codes like

byte[] bytes = rview.ServerReport.Render(format, deviceInfo, out mimeType, out encoding, out extension, out streamids, out warnings);
Response.OutputStream.Write(bytes, 0, bytes.Length);
Attachment reportAttachment = new Attachment(Response.OutputStream.Write(bytes,0,bytes.Length),"ado"); //Here I go wrong

Thanx in advance

Answer 1

Maybe I getting this wrong (I know little about SSRS) but I think you should

1. Save the file to the file system

   System.IO.File.WriteAllBytes("c:\temp\temp.pdf", bytes);
   

2. Send the file by email

   MailMessage mail = new MailMessage();
   mail.From        = "Me";
   mail.To          = "You";
   mail.Subject     = "Subject";
   mail.Body        = "Body";
   mail.BodyFormat  = MailFormat.Html;
   mail.Attachments.Add(new MailAttachment("c:\temp\temp.pdf"));
   
   
   try
   {
      SmtpMail.Send(mail); 
   }
   catch(Exception ex)
   {
      Response.Write("Ouch! " + ex.Message);
   }
   

Answer 2

Instead of saving the pdf to the file system first, you could try to use the byte[] returned from the report server and attach this:

MemoryStream ms = new MemoryStream(bytes);

mail.Attachments.Add(new Attachment(ms, "temp.pdf"));

For a quick fudge on one of my reports I did the following:

WebClient client = new WebClient();

byte[] bytes = client.DownloadData("http://localhost/ReportServer/Pages/ReportViewer.aspx? * report name * &rs%3aFormat=PDF");

MemoryStream ms = new MemoryStream(bytes);

mail.Attachments.Add(new Attachment(ms, "temp.pdf"));

Hope this is helpful