Click here to Skip to main content
Click here to Skip to main content
Go to top

Send Mail and Print Report in Report Viewer Control

, 29 Dec 2008
Rate this:
Please Sign up or sign in to vote.
This article demonstrates the implementation of Print and Send Mail operation in Report Viewer

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:

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:

Conclusion

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

History

  • 29th December, 2008: Initial post 

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

santosh poojari
Technical Lead
India India
Whatsup-->Exploring--> MVC/HTML5/Javascript & Virtualization.......!
www.santoshpoojari.blogspot.com

Comments and Discussions

 
GeneralMy vote of 1 PinmemberDavid Catriel2-Feb-14 10:43 
SuggestionPrint report without preview Pinmembermic2128-May-13 1:35 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Mobile
Web01 | 2.8.140922.1 | Last Updated 29 Dec 2008
Article Copyright 2008 by santosh poojari
Everything else Copyright © CodeProject, 1999-2014
Terms of Service
Layout: fixed | fluid