how to send mail from window service using ReportViewer without showing report

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

VS2008

, +

I want to send report using window service.
I have report server from where get a report on report viewer.
I have done in window form but I want to use this report in window service to send email as attachment.

My code is

C#

public class Service1 : System.ServiceProcess.ServiceBase
	{
protected override void OnStart(string[] args)
    {
ViewReport viewer=new ViewReport(); 
    
                ViewReport viewer=new ViewReport(); 
    
                   reportName = "DailyAttendanceReport";
                            viewer.GetConnectionOfReportServer();
                            viewer.getReportFrmServer(reportName, param);
                            viewer.Visible = true;
                            viewer.ProcessingMode = ProcessingMode.Local; 
                           
                            Thread th = new Thread(() => SendEmail("abc@gmail.com", "def@gmail.com", "password", "Automatic Mail sending", "Successfully working contact", "Attendence.xls"));
                            th.Start();
                   
 }
}

C#

public  class ViewReport:ReportViewer
   {
     private ReportViewer reportViewer1=new ReportViewer();
     bool flag = true;
     string[] ldata = new string[2];


public void GetConnectionOfReportServer()
     {
        try
          {
              NetworkCredential credential = new NetworkCredential("administrator", "password", "database");
              this.reportViewer1.ServerReport.ReportServerCredentials.NetworkCredentials = credential;

              //select where the report should be generated with the report viewer control or on the report server using the SSRS service.
              this.reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote;
              this.reportViewer1.ServerReport.ReportServerUrl = new Uri(@"http://xxx.xxx.xxx.xxx/ReportServer");
          }

          catch (Exception ex)
          {
              
          }


     }
public void getReportFrmServer(string report, string[] param)
     {
          if (flag)
          {
              reportName = report;
              flag = false;
          }

          try
          {
              this.reportViewer1.ServerReport.ReportPath = "/Report From_Iris_New/" + report;
              if (report == "DailyAttendanceReport")
              {
                  List<ReportParameter> myParams = new List<ReportParameter>();
                  myParams.Add(new ReportParameter("dailyDate", param[0]));
                  ReportParameter p = new ReportParameter("contractorname");
                  if (param[1] == "null")
                  {
                      p.Values.Add(null);
                      myParams.Add(p);
                  }
                  else
                  {
                      p.Values.Add(param[1]);
                      myParams.Add(p);
                  }
                  ReportParameter q = new ReportParameter("sitename");
                  if (param[2] == "null")
                  {
                      q.Values.Add(null);
                      myParams.Add(q);
                  }
                  else
                  {
                      q.Values.Add(param[2]);
                      myParams.Add(q);
                  }
                  this.reportViewer1.ServerReport.SetParameters(myParams);  //here this proccess stop
              
              }


             this.reportViewer1.RefreshReport();
         }
         catch (Exception exception)
         {
            
         }

     }
}

reportViewer1generates report but I want to send this reoprt as attachment.
I do not want to view report.

Posted 7-Jul-13 19:48pm

Member 7909353

Updated 7-Jul-13 20:16pm

v4

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Member 7909353 · Accepted Answer · 2013-07-07T22:16:00

C#

byte[] file= viewer.getReportFrmServer(reportName, param);

                          MemoryStream s = new MemoryStream(file);
                          s.Seek(0, SeekOrigin.Begin);
                          Attachment a = new Attachment(s, "myReport.pdf");
 Thread th = new Thread(() => SendEmail("abc@gmail.com", "def@gmail.com", "password", "Automatic Mail sending", "Successfully working contact", "Attendence.xls"));
                            th.Start();

C#

public void getReportFrmServer(string report, string[] param)
     {
          if (flag)
          {
              reportName = report;
              flag = false;
          }

          try
          {
              this.reportViewer1.ServerReport.ReportPath = "/Report From_Iris_New/" + report;
              if (report == "DailyAttendanceReport")
              {
                  List<ReportParameter> myParams = new List<ReportParameter>();
                  myParams.Add(new ReportParameter("dailyDate", param[0]));
                  ReportParameter p = new ReportParameter("contractorname");
                  if (param[1] == "null")
                  {
                      p.Values.Add(null);
                      myParams.Add(p);
                  }
                  else
                  {
                      p.Values.Add(param[1]);
                      myParams.Add(p);
                  }
                  ReportParameter q = new ReportParameter("sitename");
                  if (param[2] == "null")
                  {
                      q.Values.Add(null);
                      myParams.Add(q);
                  }
                  else
                  {
                      q.Values.Add(param[2]);
                      myParams.Add(q);
                  }
                  this.reportViewer1.ServerReport.SetParameters(myParams); 

              }


           byte[] returnValue = null;
             string format = "PDF";
             string deviceinfo = "";
             string mimeType = "";
             string encoding = "";
             string extension = "pdf";
             string[] streams = null;
             Warning[] warnings = null;

             returnValue = reportViewer1.ServerReport.Render(format, deviceinfo, out mimeType, out encoding, out extension, out streams, out warnings);
             this.reportViewer1.RefreshReport();
             return returnValue;
         }
         catch (Exception exception)
         {

         }

     }