public void GenerateReportnew() { Document doc = new Document(r, mleft, mright, mtop, mbottom); //fs = new FileStream(fname, FileMode.Create); fs = HttpContext.Current.Response.OutputStream; PdfWriter writer = PdfWriter.GetInstance(doc, fs); tbl = new PdfPTable(reptab.Columns.Count); tbl.SetWidths(colwid); tbl.TotalWidth = (595 - mleft - mright); tbl.LockedWidth = true; tbl.SetWidths(colwid); tbl.HorizontalAlignment = 0; tbl.SpacingBefore = 10f; tbl.SpacingAfter = 10f; /*for (int i = 0; i < repheaders.Length; i++) * { * PdfPCell cell = new PdfPCell(new Phrase(repheaders[i])); * cell.Colspan = reptab.Columns.Count; * cell.Border = 0; * cell.HorizontalAlignment = 1; * tbl.AddCell(cell); * }*/ for (int rh = 0; rh < reptab.Columns.Count; rh++) { tbl.AddCell(reptab.Columns[rh].ColumnName.ToUpper()); } for (int row = 0; row < reptab.Rows.Count; row++) { for (int col = 0; col < reptab.Columns.Count; col++) { tbl.AddCell(reptab.Rows[row][reptab.Columns[col]].ToString()); } } doc.Open(); MyPager ev = new MyPager(); writer.PageEvent = ev; doc.Add(tbl); doc.Close(); //openpdf(fname); }
public void GenerateReport() { Document doc = new Document(r, mleft, mright, mtop, mbottom); fs = new FileStream(fname, FileMode.Create); Font tblfnt = new Font(Font.FontFamily.HELVETICA, 8, 0); Font tblheadfnt = new Font(Font.FontFamily.HELVETICA, 12, 1); PdfWriter writer = PdfWriter.GetInstance(doc, fs); tbl = new PdfPTable(reptab.Columns.Count); tbl.SetWidths(colwid); tbl.TotalWidth = (595 - mleft - mright); tbl.LockedWidth = true; tbl.SetWidths(colwid); tbl.HorizontalAlignment = 0; tbl.SpacingBefore = 10f; tbl.SpacingAfter = 10f; for (int i = 0; i < repheaders.Length; i++) { PdfPCell cell = new PdfPCell(new Phrase(repheaders[i], tblheadfnt)); cell.Colspan = reptab.Columns.Count; cell.Border = 0; cell.HorizontalAlignment = 1; tbl.AddCell(cell); } for (int rh = 0; rh < reptab.Columns.Count; rh++) { tbl.AddCell(reptab.Columns[rh].ColumnName.ToUpper()); } for (int row = 0; row < reptab.Rows.Count; row++) { for (int col = 0; col < reptab.Columns.Count; col++) { PdfPCell cell; String dtype = reptab.Rows[row][reptab.Columns[col]].GetType().Name; if (reptab.Rows[row][reptab.Columns[col]].GetType().Name.Equals("Double")) { cell = new PdfPCell(new Phrase(Convert.ToDouble(reptab.Rows[row][reptab.Columns[col]]).ToString("n2").ToString(), tblfnt)); cell.HorizontalAlignment = 2; } else if (reptab.Rows[row][reptab.Columns[col]].GetType().Name.Equals("Int32")) { cell = new PdfPCell(new Phrase(reptab.Rows[row][reptab.Columns[col]].ToString(), tblfnt)); cell.HorizontalAlignment = 2; } else { cell = new PdfPCell(new Phrase(reptab.Rows[row][reptab.Columns[col]].ToString(), tblfnt)); cell.HorizontalAlignment = 0; } tbl.AddCell(cell); } } doc.Open(); MyPager ev = new MyPager(); writer.PageEvent = ev; doc.Add(tbl); doc.Close(); //openpdf(fname); }