datagridview to custom iTextsharp report

 Hi ,

 

Please use the followin sample code

 

PdfPTable t;

DataSet dsrepname = objComBl.GetRepName();

int j;

for (j = 0; j <= dsrepname.Tables[0].Rows.Count - 1; j++)

{

string repname, dateyear;

repname = dsrepname.Tables[0].Rows[j]["RepName"].ToString();

dateyear = dsrepname.Tables[0].Rows[j]["Date Created"].ToString();

string Rep = repname;

if (!Directory.Exists(dir))

{

// if it doesn't exist, create

Directory.CreateDirectory(dir);

}

doc1 = new Document(iTextSharp.text.PageSize.A4, 0.75f, 0.75f, 42, 35);

pdfFilePath = dir + "\\" + repname + " " + dateyear + ".pdf";

//if (!(File.Exists(pdfFilePath)))

//{

DataSet dsFinishOrdDetails = objComBl.GetFinishOrdPrLoad(Rep);

int i;

string pdfRepGroupName, pdfRepGroupLogo, pdfRGAddress, pdfRGCity, pdfRGState

, pdfRGZip, pdfRGPhoneNo, pdfSalesRepName,

pdfVendor, pdforderdate, pdfcustomer, pdfcity, pdfstate,

pdforignial, pdfshipped, pdfcommission, pdfmonthyear;

for (i = 0; i <= dsFinishOrdDetails.Tables[0].Rows.Count - 1; i++)

{

pdfRepGroupName = dsFinishOrdDetails.Tables[0].Rows[i]["RepGroupName"].ToString();

pdfRGAddress = dsFinishOrdDetails.Tables[0].Rows[i]["Address1"].ToString();

pdfRGCity = dsFinishOrdDetails.Tables[0].Rows[i]["City"].ToString();

pdfRGState = dsFinishOrdDetails.Tables[0].Rows[i]["State"].ToString();

pdfRGZip = dsFinishOrdDetails.Tables[0].Rows[i]["Zip"].ToString();

pdfSalesRepName = dsFinishOrdDetails.Tables[0].Rows[i]["RepName"].ToString();

pdfVendor = dsFinishOrdDetails.Tables[0].Rows[i]["Vendor"].ToString();

pdfRGPhoneNo = dsFinishOrdDetails.Tables[0].Rows[i]["Phone"].ToString();

pdforderdate = dsFinishOrdDetails.Tables[0].Rows[i]["Order Date"].ToString();

pdfcustomer = dsFinishOrdDetails.Tables[0].Rows[i]["Customer Name"].ToString();

pdfcity = dsFinishOrdDetails.Tables[0].Rows[i]["C_City"].ToString();

pdfstate = dsFinishOrdDetails.Tables[0].Rows[i]["C_State"].ToString();

pdforignial = dsFinishOrdDetails.Tables[0].Rows[i]["Original $"].ToString();

// d2 = ((Convert.ToDecimal(gv_CRWS_details.Rows[e.RowIndex].Cells["$ Shipped amount"].Value)) * d1) / 100;

decimal pdforignial2 = Math.Round(Convert.ToDecimal(pdforignial), 2, MidpointRounding.AwayFromZero);

pdforignial = pdforignial2.ToString();

pdfshipped = dsFinishOrdDetails.Tables[0].Rows[i]["Shipped $"].ToString();

decimal pdfshipped2 = Math.Round(Convert.ToDecimal(pdfshipped), 2, MidpointRounding.AwayFromZero);

pdfshipped = pdfshipped2.ToString();

pdfmonthyear = dsFinishOrdDetails.Tables[0].Rows[i]["Date Created"].ToString();

pdfcommission = dsFinishOrdDetails.Tables[0].Rows[i]["Commission Amount"].ToString();

decimal pdfcommission2 = Math.Round(Convert.ToDecimal(pdfcommission), 2, MidpointRounding.AwayFromZero);

pdfcommission = pdfcommission2.ToString();

var f = FontFactory.GetFont("TimesNewRoman", 10, 1, iTextSharp.text.BaseColor.BLACK); // + Sep 26th 2013

var f1 = FontFactory.GetFont("TimesNewRoman", 9, 1, iTextSharp.text.BaseColor.BLACK); // = Sep 26th 2013

t = new PdfPTable(7);

// t.DefaultCell.Border = 0;

DirectoryInfo di = new DirectoryInfo(dir + "\\");

fs1 = new FileStream(pdfFilePath, FileMode.Create, FileAccess.ReadWrite);

wri1 = PdfWriter.GetInstance(doc1, fs1);

doc1.Open();//Open Document to write

string RepgroupName = pdfRepGroupName;

DataTable dtRepGrpInfo = new DataTable();

//int repGrpId;

//int.TryParse(repgrpid, out repGrpId);

dtRepGrpInfo = objComBl.GetLogo(RepgroupName);

byte[] raw;

int len;

string printinfo; //+ Nov 15th 2013

Paragraph objPrintInfo = new Paragraph();

PdfPCell cell;

if (dtRepGrpInfo.Rows.Count > 0)

{

raw = (byte[])(dtRepGrpInfo.Rows[0]["Logo"]);

len = raw.Length;

//printinfo = dtRepGrpInfo.Rows[0]["RepGroupName"] + "\n" + dtRepGrpInfo.Rows[0]["Email"] +

//"\n" + dtRepGrpInfo.Rows[0]["Phone"];

if (len > 0)

{

iTextSharp.text.Image jpg = iTextSharp.text.Image.GetInstance(raw);

//Resize image depend upon your need

//jpg.ScaleToFit(170f, 86f);

jpg.Alignment = Element.ALIGN_JUSTIFIED;

//jpg.Border = iTextSharp.text.Rectangle.BOX;

//jpg.BorderWidth = 1f;

cell = new PdfPCell(jpg);

cell.Border = 0;

cell.AddElement(jpg);

//// cell.AddElement(new Paragraph(printinfo, f1));

}

else

{

cell = new PdfPCell();

cell.Border = 0;

//cell.AddElement(new Paragraph("\n\n\n\n" + printinfo, f1));

}

}

else

{

cell = new PdfPCell();

}

// cell.Rowspan = 2;

t.AddCell(cell);

PdfPCell pdfrepgroup = new PdfPCell(new Phrase(pdfRepGroupName + "\n" + pdfRGAddress + "\n" + pdfRGCity + "\n" + pdfRGState + "\n" + pdfRGPhoneNo, f1));

pdfrepgroup.Border = 0;

// pdfrepgroup = new PdfPCell(new Phrase(pdfRepGroupName, f1));

pdfrepgroup.Colspan = 7;

pdfrepgroup.HasBorder(iTextSharp.text.Rectangle.NO_BORDER);

pdfrepgroup.BorderColor = BaseColor.WHITE;

//pdfrepgroup.BorderColorBottom = BaseColor.BLACK;

//pdfrepgroup.BorderColorTop = BaseColor.BLACK;

pdfrepgroup.HorizontalAlignment = 2; //0=Left, 1=Centre, 2=Right

t.AddCell(pdfrepgroup);

PdfPCell cellheader = new PdfPCell(new Phrase("Sales Rep Commission Report " + pdfmonthyear, f));

cellheader.Border = 0;

cellheader.HasBorder(iTextSharp.text.Rectangle.NO_BORDER);

cellheader.BorderColor = BaseColor.WHITE;

cellheader.BorderColorBottom = BaseColor.WHITE;

cellheader.BorderColorTop = BaseColor.WHITE;

//cellheader.BackgroundColor = BaseColor.LIGHT_GRAY;

cellheader.Colspan = 7;

cellheader.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right

t.AddCell(cellheader);

Paragraph objPara = new Paragraph();

PdfPCell p1 = new PdfPCell(new Phrase(pdfSalesRepName, f));// { Border = 0, BorderColor = BaseColor.WHITE, BorderColorBottom = BaseColor.WHITE, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

p1.Border = 1;

p1.BorderColorBottom = BaseColor.BLACK;

p1.BorderColorLeft = BaseColor.WHITE;

p1.BorderColorRight = BaseColor.WHITE;

p1.BorderColorTop = BaseColor.WHITE;

p1.Colspan = 7;

//p1.HasBorder(iTextSharp.text.Rectangle.NO_BORDER);

//p1.BorderColor = BaseColor.WHITE;

t.AddCell(p1);

//PdfPCell objPDFCell = new PdfPCell(objPara);

//objPDFCell.Border = 0;

//objPDFCell.HasBorder(iTextSharp.text.Rectangle.NO_BORDER);

//objPDFCell.BorderColor = BaseColor.WHITE;

//t.AddCell(new PdfPCell(objPara) { Colspan = 7 });

t.AddCell(new PdfPCell(new Phrase("Vendor", f)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.BLACK });

t.AddCell(new PdfPCell(new Phrase("Order Date", f)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.BLACK });

t.AddCell(new PdfPCell(new Phrase("Customer", f)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.BLACK });

t.AddCell(new PdfPCell(new Phrase("City State", f)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.BLACK });

//t.AddCell(new PdfPCell(new Phrase("State", f)) { BackgroundColor=BaseColor.LIGHT_GRAY});

t.AddCell(new PdfPCell(new Phrase("Original $", f)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.BLACK });

t.AddCell(new PdfPCell(new Phrase("Shipped $", f)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.BLACK });

t.AddCell(new PdfPCell(new Phrase("Commission Amount", f)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.BLACK });

PdfPCell cellheader1 = new PdfPCell(new Phrase("", f));

cellheader1.Border = 1;

// cellheader1.HasBorder(iTextSharp.text.Rectangle.NO_BORDER);

cellheader1.BorderColor = BaseColor.BLACK;

cellheader1.BorderColorTop = BaseColor.BLACK;

cellheader1.BorderColorBottom = BaseColor.BLACK;

//cellheader.BackgroundColor = BaseColor.LIGHT_GRAY;

cellheader1.Colspan = 7;

cellheader1.HorizontalAlignment = 1; //0=Left, 1=Centre, 2=Right

t.AddCell(cellheader1);

for (i = 0; i <= dsFinishOrdDetails.Tables[0].Rows.Count - 1; i++)

{

string pdfRepGroupName1 = dsFinishOrdDetails.Tables[0].Rows[i]["RepGroupName"].ToString();

pdfRGAddress = dsFinishOrdDetails.Tables[0].Rows[i]["Address1"].ToString();

pdfRGCity = dsFinishOrdDetails.Tables[0].Rows[i]["City"].ToString();

pdfRGState = dsFinishOrdDetails.Tables[0].Rows[i]["State"].ToString();

pdfRGZip = dsFinishOrdDetails.Tables[0].Rows[i]["Zip"].ToString();

pdfSalesRepName = dsFinishOrdDetails.Tables[0].Rows[i]["RepName"].ToString();

pdfVendor = dsFinishOrdDetails.Tables[0].Rows[i]["Vendor"].ToString();

pdfRGPhoneNo = dsFinishOrdDetails.Tables[0].Rows[i]["Phone"].ToString();

// pdfRepGroupName = dsFinishOrdDetails.Tables[0].Rows[0]["Vendor"].ToString();

pdforderdate = dsFinishOrdDetails.Tables[0].Rows[i]["Order Date"].ToString();

pdfcustomer = dsFinishOrdDetails.Tables[0].Rows[i]["Customer Name"].ToString();

pdfcity = dsFinishOrdDetails.Tables[0].Rows[i]["C_City"].ToString();

pdfstate = dsFinishOrdDetails.Tables[0].Rows[i]["C_State"].ToString();

pdforignial = dsFinishOrdDetails.Tables[0].Rows[i]["Original $"].ToString();

// d2 = ((Convert.ToDecimal(gv_CRWS_details.Rows[e.RowIndex].Cells["$ Shipped amount"].Value)) * d1) / 100;

decimal pdforignial1 = Math.Round(Convert.ToDecimal(pdforignial), 2, MidpointRounding.AwayFromZero);

pdforignial = pdforignial1.ToString();

pdfshipped = dsFinishOrdDetails.Tables[0].Rows[i]["Shipped $"].ToString();

decimal pdfshipped1 = Math.Round(Convert.ToDecimal(pdfshipped), 2, MidpointRounding.AwayFromZero);

pdfshipped = pdfshipped1.ToString();

pdfmonthyear = dsFinishOrdDetails.Tables[0].Rows[i]["Date Created"].ToString();

pdfcommission = dsFinishOrdDetails.Tables[0].Rows[i]["Commission Amount"].ToString();

decimal pdfcommission1 = Math.Round(Convert.ToDecimal(pdfcommission), 2, MidpointRounding.AwayFromZero);

pdfcommission = pdfcommission1.ToString();

if (pdfRepGroupName1 == pdfRepGroupName)

{

//t.AddCell(new PdfPCell(new Phrase(, f1)));

if (pdfstate == "TOTAL")

{

t.AddCell(new PdfPCell(new Phrase(pdfVendor, f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdforderdate, f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdfcustomer, f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdfcity + " " + pdfstate, f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdforignial, f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdfshipped, f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdfcommission, f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase("", f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase("", f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase("", f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase("", f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase("", f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase("", f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase("", f1)) { Border = 1, BorderColor = BaseColor.BLACK, BorderColorBottom = BaseColor.BLACK, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

}

else

{

t.AddCell(new PdfPCell(new Phrase(pdfVendor, f1)) { Border = 0, BorderColor = BaseColor.WHITE, BorderColorBottom = BaseColor.WHITE, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdforderdate, f1)) { Border = 0, BorderColor = BaseColor.WHITE, BorderColorBottom = BaseColor.WHITE, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdfcustomer, f1)) { Border = 0, BorderColor = BaseColor.WHITE, BorderColorBottom = BaseColor.WHITE, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdfcity + " " + pdfstate, f1)) { Border = 0, BorderColor = BaseColor.WHITE, BorderColorBottom = BaseColor.WHITE, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdforignial, f1)) { Border = 0, BorderColor = BaseColor.WHITE, BorderColorBottom = BaseColor.WHITE, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdfshipped, f1)) { Border = 0, BorderColor = BaseColor.WHITE, BorderColorBottom = BaseColor.WHITE, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

t.AddCell(new PdfPCell(new Phrase(pdfcommission, f1)) { Border = 0, BorderColor = BaseColor.WHITE, BorderColorBottom = BaseColor.WHITE, BorderColorLeft = BaseColor.WHITE, BorderColorRight = BaseColor.WHITE, BorderColorTop = BaseColor.WHITE });

}

}

}

// t.DefaultCell.Border = iTextSharp.text.Rectangle.NO_BORDER;

// t.DefaultCell.BorderColor = iTextSharp.text.Color.WHITE;

doc1.Add(t);

doc1.Close();

// con.Close();

wri1.Close();