export crystal report to mail

[Rama Jayapal]

i have to generate bills for the specified candidate

so in order to generate a single person report i wrote the following code



Datatable dt=new Datatable;

DataAdapter da=new DataAdapter();

da.Fill(dt,Gridview.Selectedvalue);

dataset ds=new dataset();

ds.Tables.Add(dt);

ReportDocument rd=new ReportDocument();

rd.Load("CrystalReport.rpt");

rd.SetDatasource(ds);

CrystalReportViewer.Reportsource=rd;

CrystalReportViewer.DataBind();



1.i need to have two bills .how can include another page on the same report.

2. I have written the above code in GridView.SelectedIndexChanged event

now when i select a person profile the corresponding report is generated

now i need to send this in mail as an attachment

how can i do this

when i try to export the report ,the report disappears

what could be wrong

can anyone help me on this regard

Rama

[dip_developer]

i have to generate bills for the specified candidate

so in order to generate a single person report i wrote the following code



Datatable dt=new Datatable;

DataAdapter da=new DataAdapter();

da.Fill(dt,Gridview.Selectedvalue);

dataset ds=new dataset();

ds.Tables.Add(dt);

ReportDocument rd=new ReportDocument();

rd.Load("CrystalReport.rpt");

rd.SetDatasource(ds);

CrystalReportViewer.Reportsource=rd;

CrystalReportViewer.DataBind();



1.i need to have two bills .how can include another page on the same report.

2. I have written the above code in GridView.SelectedIndexChanged event

now when i select a person profile the corresponding report is generated

now i need to send this in mail as an attachment

how can i do this

when i try to export the report ,the report disappears

what could be wrong

can anyone help me on this regard

Rama

there is no concept of adding page to a crystal report......
Add another Detail section to your report for the second bill.

secondly, export your report to a format like pdf and attach it to mail....here your concept is right....
but I dont know how your report is disappearing......

[radcaesar]

Hey Export that to PDF and Send it through mail.

Here is the code snippet from VelocityReviews.

'----------- create physical pdf --------

oRpt.ExportToDisk(CrystalDecisions.Shared.ExportFo rmatType.PortableDocFormat,
"C:\XML\" & Trim(Request.QueryString("fn")) & ".pdf")

Response.ClearContent()
Response.ClearHeaders()
Response.ContentType = "application/pdf"
Response.WriteFile(FName)
Response.Flush()
Response.Close()
System.IO.File.Delete(FName)

'------------- send mail begin ---------------
Dim email = New MailMessage
email.BodyFormat = MailFormat.Text
Dim attach = New MailAttachment("C:\XML24\" &
Trim(Request.QueryString("fn")) & ".pdf")


email.From = ""
email.To = ""
email.Subject = "E-MAIL TEST"
email.Body = "This is an e-mail test. Sending e-mail
through asp.net"
email.Attachments.Add(attach)
' Set the SMTP server and send the email
SmtpMail.SmtpServer = "192.168.000.00"
SmtpMail.Send(email)
'------------- send mail end ---------------

[rudenaggar]

you can send a crystal report by email from just one button click. Please find the following link :

http://csharp.net-informations.com/c...orts-email.htm

ruden.