Send Mail and Print Report in Report Viewer Control

Introduction

I have been working with Report Viewer and have come across a lot of problems related to print option and mailing reports as an attachment to end users. This article aims to help developers facing similar problems.

Bind RDLC -to Report Viewer

Please refer to the following article:

• Dynamic Binding Of RDLC To ReportViewer

Send Mail Attachment of Report in Report Viewer

One can drag the button and code the lines below so as to send a report as an attachment. In the code below, the attachment can be PDF, HTML, DOC, Excel, etc. For PDF, one needs to code reportViewer.LocalReport.Render("PDF", null,... The code here is self explanatory.

using System.Net.Mail;
private void SendMail(ReportViewer reportViewer)
{
            Warning[] warnings;
            string[] streamids;
            string mimeType;
            string encoding;
            string extension;

            byte[] bytes = reportViewer.LocalReport.Render
		("Excel", null, out mimeType, out encoding, out extension, out 
		streamids, out warnings);

            MemoryStream memoryStream = new MemoryStream(bytes);
            memoryStream.Seek(0, SeekOrigin.Begin);

            MailMessage message = new MailMessage();
            Attachment attachment = new Attachment(memoryStream,"BusinessReport.xls");
            message.Attachments.Add(attachment);

            message.From = new MailAddress("santosh.poojari@gmail.com");
            message.To.Add("santosh.poojari@gmail.com");         
           
            message.CC.Add("santosh.poojari@gmail.com");

            message.Subject = "Business Report";
            message.IsBodyHtml = true;

            message.Body = "Please find Attached Report herewith."
            
            if (ConfigurationManager.AppSettings["SendMail"].ToString() == "Y")
            {
                SmtpClient smtp = new SmtpClient("SMTP Server Name");        
                smtp.Send(message);
            }
	    else
	    {
		//This is for testing.
		SmtpClient smtp = new SmtpClient();        
                smtp.Send(message);
	    }

            memoryStream.Close();
            memoryStream.Dispose();
 }

Design HTML

< rsweb:ReportViewer ID="ReportViewer1" runat="server" 
	Font-Names="Verdana" Font-Size="8pt"
                >
                <LocalReport ReportPath="Report.rdlc" >
                   <DataSources >
                        < rsweb:ReportDataSource / >
                    </DataSources >
                </LocalReport >
            </rsweb:ReportViewer >  

Web Configuration

One can test this code snippet by adding the below configuration in web config.

< system.net >
    < mailSettings >
   	< smtp deliveryMethod="SpecifiedPickupDirectory" >
    	     < specifiedPickupDirectory pickupDirectoryLocation="C:\Test\" / >
	</smtp >
    </mailSettings>
</system.net >  

Print Operation in Report Viewer

Please refer to the link below:

• Print Report in ReportViewer Control

Conclusion

Hope I met the expectation of developers working on similar problems.

History

• 29^th December, 2008: Initial post