How to send a crystal report generated to a mail recipient

Question

0.00/5 (No votes)

See more:

hello everyone.

i have a project am working on, all i wanted to do i created a crystal report but what i want to do is, i want the crystal report created to send as an pdf mail to the recipient without having to view it, it should just send as a mail at a click. below is my code

C#

{
    MealTicket ticket = new MealTicket ();
    DataSet ds = new DataSet ();
    frmShowTicket ticketfrm = new frmShowTicket();
    rptTicket rpttik = new rptTicket ();
    string ticketno;
    ticketno = textBox4.Text;
    ds = ticket.GetTicket(ticketno);
    if (ds.Tables[0].Rows.Count > 0)
    {
        rpttik.SetDataSource(ds.Tables[0].DefaultView);
        ticketfrm.crv.ReportSource = rpttik;
        ticketfrm.Show();
    }
    else
    {
        MessageBox.Show("No Ticket to generate or Ticket ID is incorrect");
    }

    button1.Enabled = true;
    button2.Enabled = true;
    textBox1.Text = "";
    comboBox1.Text = "";
    comboBox2.Text = "";
    textBox3.Text = "";
    textBox4.Text = "";

}

What I have tried:

I dont know how to go about it but here is my code of sending mail which is working fine but how can i add the crystal report to the mail as an attachement.

This is an example of one my way of sending email and this is working fine

private void Button1_Click(object sender, EventArgs e)
{

if (txtEmail.Text == "")
{
MessageBox.Show("Enter your email", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtEmail.Focus();
return;
}
try
{
Cursor = Cursors.WaitCursor;
timer1.Enabled = true;
DataSet ds = new DataSet();
SqlConnection con = new SqlConnection(cs.DBcon);
con.Open();
SqlCommand cmd = new SqlCommand("SELECT Password FROM User_Registration Where Email = '" + txtEmail.Text + "'", con);

SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
con.Close();
if (ds.Tables[0].Rows.Count > 0)
{
string recipient;
recipient = txtEmail.Text;
MailMessage Msg = new MailMessage();
// Sender e-mail address.
Msg.From = new MailAddress("jinny@gmail.com");
// Recipient e-mail address.
Msg.To.Add(recipient);
Msg.Subject = "Your Password Details";
Msg.Body = "Your Password is: " + Convert.ToString(ds.Tables[0].Rows[0]["Password"]) + "";
Msg.IsBodyHtml = true;
// your remote SMTP server IP.
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.Credentials = new System.Net.NetworkCredential("jinny@gmail.com", "Pass");
smtp.EnableSsl = true;
smtp.Send(Msg);
MessageBox.Show(("Password Successfully sent " + ("\r\n" + "Please check your mail")), "Thank you", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Hide();
st1 = lblUser.Text;
st2 = "Password Is Recovered";
cf.LogFunc(st1, System.DateTime.Now, st2);
frmLogin LoginForm1 = new frmLogin();
LoginForm1.Show();
LoginForm1.UserID.Text = "";
LoginForm1.Password.Text = "";
LoginForm1.cmbUsertype.Text = "";
LoginForm1.ProgressBar1.Visible = false;

LoginForm1.cmbUsertype.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}

Posted 27-May-16 10:10am

Member 12414126

Updated 27-May-16 21:08pm

Add a Solution

2 solutions

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)

Dave Kreskowiak · Accepted Answer · 2016-05-27T13:20:00

You can't add a CR report to an email and send it. You CAN, however, export the report to a PDF and send that as an attachment.

Another option is to send the recipient a link to a website that will generate the report so long as your site supports rendering a CR Report using some kind of data from a URL to tell it which report and any other information required by that particular user.

Salman622 · Accepted Answer · 2016-05-27T21:08:00

Hi!!!

below link will explain you how to Convert Crystal Report to PDF
crystal report to pdf

for sending email with attachement use below method

C#

private void SendEmail(string pdfpath,string mailfrom,string mailto) 
{
    try
    {
        MailMessage m = new MailMessage();
        System.Net.Mail.SmtpClient sc = new System.Net.Mail.SmtpClient();

        m.From = new System.Net.Mail.MailAddress(mailfrom);
        m.To.Add(mailto);

        m.Subject = "Your Subject";


        // what I must do for sending a pdf with this email 

        m.Body = "Your Body";
        m.Attachments.Add(new Attachment(pdfpath));
        sc.Host = "Youyr Host"; // here is the smt path

        sc.Send(m);
    }
    catch (Exception ex)
    {
        error.Visible = true;
        lblErrorMessage.Text = ex.Message;
    }
}

How to send a crystal report generated to a mail recipient

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0