Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: Need to develope a dll Post Reply Post New Topic
Author Message
manikantaj
Newbie
Newbie


Joined: 24 Oct 2010
Online Status: Offline
Posts: 1
Quote manikantaj Replybullet Topic: Need to develope a dll
    Posted: 25 Oct 2010 at 12:03am
Hi,
 
     I want to develope a dll with the below code using .net class library project. I am not able to get some references. What are the name spaces i have to use in class library. Especially i am using crystal report viewer and set its visibility to false because i dont want to open the report with viewer instead i want to export it to pdf.
 
   Please go thorugh the belwo code and respond me asap.
 
Thanks,
Raj

private void GenerateReport()

{

try

{

WriteError("Report Generation Started ......" + DateTime.Today.ToString("dd-mm-yy"));

Form1 form = new Form1();

form.Visible = false;

ConnectionInfo crConnectionInfo = new ConnectionInfo();

ReportDocument rd = new ReportDocument();

WriteError("1");

rd.Load(@"c:\Agreements.rpt");

WriteError("2");

crConnectionInfo.ServerName = "BG4WS0268";

crConnectionInfo.DatabaseName = "TestUMDB";

crConnectionInfo.IntegratedSecurity = true;

// crConnectionInfo.UserID = "spdev";

// crConnectionInfo.Password = "spdev";

crDatabase = rd.Database;

crTables = crDatabase.Tables;

WriteError("3");

//ParameterField f1 = CrystalReportViewer1.ParameterFieldInfo[0];

//ParameterDiscreteValue v1 = new ParameterDiscreteValue();

// ParameterValues pv = new ParameterValues();

for (int i = 0; i < crTables.Count; i++)

{

crTable = crTables;

crTableLogOnInfo = crTable.LogOnInfo;

crTableLogOnInfo.ConnectionInfo = crConnectionInfo;

crTable.ApplyLogOnInfo(crTableLogOnInfo);

crTable.Location = crConnectionInfo.DatabaseName + ".dbo." +

crTable.Location.Substring(crTable.Location.LastIndexOf(".") + 1);

}

WriteError("After FOR loop - 1");

crystalReportViewer1.ReportSource = rd;

WriteError("After FOR loop - 2");

crystalReportViewer1.Visible = false;

string Directtoy = @"c:\Reports";

string FileName = "Agreements" + DateTime.Today.ToString("dd-mm-yy") + ".pdf";

if (!Directory.Exists(Directtoy))

{

Directory.CreateDirectory(Directtoy);

}

WriteError("After IF statement - 1");

rd.ExportToDisk(ExportFormatType.PortableDocFormat, Directtoy + "/" + FileName);

WriteError("4");

form.Visible = false;

form.Width = 0;

form.Height = 0;

sendmail("Your Report has been created under below path. <br/> The Path is Directtoy" + " / " + FileName);

WriteError("Report Generated Succesfully and a Email has been sent on" + DateTime.Today.ToString("dd-mm-yy"));

this.Close();

}

catch (Exception ex)

{

WriteError(ex.Message);

sendmail(ex.Message);

}

}

private static void WriteError(string errorMessage)

{

try

{

string Directtoy = @"c:\Errors";

string FileName = DateTime.Today.ToString("dd-mm-yy") + ".txt";

if (!Directory.Exists(Directtoy))

{

Directory.CreateDirectory(Directtoy);

}

// File.Create(Directtoy+ "/" + FileName);

using (StreamWriter w = File.AppendText(Directtoy + "/" + FileName))

{

w.WriteLine("\r\nLog Entry : ");

w.WriteLine("{0}", DateTime.Now.ToString(CultureInfo.InvariantCulture));

string err = "Error in: Creating Report" +

". Error Message:" + errorMessage;

w.WriteLine(err);

w.WriteLine("__________________________");

w.Flush();

w.Close();

}

}

catch (Exception ex)

{

WriteError(ex.Message);

}

}

private void sendmail(string body)

{

System.Web.Mail.MailMessage message = new System.Web.Mail.MailMessage();

message.From = "yagnaraja.mj@sonata-software.com";

message.To = "yagnaraja.mj@sonata-software.com";

//message.To.Add(new MailAddress("sujitharaj.k@sonata-software.com"));

message.To = "ashwini.k@sonata-software.com";

// message.Cc = "mallikarjunarao.av@sonata-software.com";

message.Subject = "Report Generated Successfully";

message.Body = body;

message.BodyFormat = MailFormat.Html;

// System.Web.Mail.MailAttachment attach = new MailAttachment(@"c:\\Agreements.pdf");

// message.Attachments.Add(attach);

SmtpMail.SmtpServer = "NANDIMSG.SONATA.LOCAL";

SmtpMail.Send(message);

}

IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.