How to Generate Report in PDF in Asp.Net

Here we will create customise report in dot net. We will create pdf report file for employee details from database and generate report file.

TABLE:

CREATE TABLE [dbo].[Employees](

      [EmpID] [int] IDENTITY(1,1) NOT NULL,

      [FirstName] [varchar](50) NULL,

      [LastName] [varchar](50) NULL,

      [Salary] [int] NULL,

      [Address] [varchar](100) NULL,

      [Location] [varchar](50) NULL,

 CONSTRAINT [PK_Employee] PRIMARY KEY CLUSTERED

(

      [EmpID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

HTML CODE:

<div>

        <asp:DropDownList ID="ddlEmployees" runat="server">

        </asp:DropDownList>

        <asp:Button ID="btnReport" runat="server" Text="Generate Report" OnClick="GenerateReport" />

    </div>

    </form>

    <p>

        &nbsp;&nbsp;&nbsp;

    </p>

NAME SPACES:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using iTextSharp.text;

using iTextSharp.text.pdf;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

CODE BEHIND:

protected void Page_Load(object sender, EventArgs e)

        {

            if (!IsPostBack)

            {

                BindEmployeesDropDown();

            }

        }

        private void BindEmployeesDropDown()

        {

            ddlEmployees.DataSource = GetData("SELECT EmpID, (FirstName + ' ' + LastName) Name FROM Employees");

            ddlEmployees.DataTextField = "Name";

            ddlEmployees.DataValueField = "EmpID";

            ddlEmployees.DataBind();

        }

        private DataTable GetData(string query)

        {

            string conString = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;

            SqlCommand cmd = new SqlCommand(query);

            using (SqlConnection con = new SqlConnection(conString))

            {

                using (SqlDataAdapter sda = new SqlDataAdapter())

                {

                    cmd.Connection = con;

                    sda.SelectCommand = cmd;

                    using (DataTable dt = new DataTable())

                    {

                        sda.Fill(dt);

                        return dt;

                    }

                }

            }

        }

        protected void GenerateReport(object sender, EventArgs e)

        {

            DataRow dr = GetData("SELECT * FROM Employees where EmpID = " + ddlEmployees.SelectedItem.Value).Rows[0]; ;

            Document document = new Document(PageSize.A4, 88f, 88f, 10f, 10f);

            Font NormalFont = FontFactory.GetFont("Arial", 12, Font.NORMAL, Color.BLACK);

            using (System.IO.MemoryStream memoryStream = new System.IO.MemoryStream())

            {

                PdfWriter writer = PdfWriter.GetInstance(document, memoryStream);

                Phrase phrase = null;

                PdfPCell cell = null;

                PdfPTable table = null;

                Color color = null;

                document.Open();

                //Header Table

                table = new PdfPTable(2);

                table.TotalWidth = 500f;

                table.LockedWidth = true;

                table.SetWidths(new float[] { 0.3f, 0.7f });

                //Company Logo

                cell = ImageCell("~/images/OFF.JPG", 30f, PdfPCell.ALIGN_CENTER);

                table.AddCell(cell);

                //Company Name and Address

                phrase = new Phrase();

                phrase.Add(new Chunk("Microsoft Northwind Traders Company\n\n", FontFactory.GetFont("Arial", 16, Font.BOLD, Color.RED)));

                phrase.Add(new Chunk("107, Park site,\n", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));

                phrase.Add(new Chunk("Salt Lake Road,\n", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));

                phrase.Add(new Chunk("Seattle, USA", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));

                cell = PhraseCell(phrase, PdfPCell.ALIGN_LEFT);

                cell.VerticalAlignment = PdfCell.ALIGN_TOP;

                table.AddCell(cell);

                //Separater Line

                color = new Color(System.Drawing.ColorTranslator.FromHtml("#A9A9A9"));

                DrawLine(writer, 25f, document.Top - 79f, document.PageSize.Width - 25f, document.Top - 79f, color);

                DrawLine(writer, 25f, document.Top - 80f, document.PageSize.Width - 25f, document.Top - 80f, color);

                document.Add(table);

                table = new PdfPTable(2);

                table.HorizontalAlignment = Element.ALIGN_LEFT;

                table.SetWidths(new float[] { 0.3f, 1f });

                table.SpacingBefore = 20f;

                //Employee Details

                cell = PhraseCell(new Phrase("Employee Record", FontFactory.GetFont("Arial", 12, Font.UNDERLINE, Color.BLACK)), PdfPCell.ALIGN_CENTER);

                cell.Colspan = 2;

                table.AddCell(cell);

                cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);

                cell.Colspan = 2;

                cell.PaddingBottom = 30f;

                table.AddCell(cell);

                //Photo

                cell = ImageCell(string.Format("~/Images/OFFLAMP.JPG", dr["EmpID"]), 25f, PdfPCell.ALIGN_CENTER);

                table.AddCell(cell);

                //Name

                phrase = new Phrase();

                phrase.Add(new Chunk(dr["FirstName"] + " " + dr["LastName"] + "\n", FontFactory.GetFont("Arial", 10, Font.BOLD, Color.BLACK)));

                // phrase.Add(new Chunk("(" + dr["Title"].ToString() + ")", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)));

                phrase.Add(new Chunk("(" + "-" + ")", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)));

                cell = PhraseCell(phrase, PdfPCell.ALIGN_LEFT);

                cell.VerticalAlignment = PdfPCell.ALIGN_MIDDLE;

                table.AddCell(cell);

                document.Add(table);

                DrawLine(writer, 160f, 80f, 160f, 690f, Color.BLACK);

                DrawLine(writer, 115f, document.Top - 200f, document.PageSize.Width - 100f, document.Top - 200f, Color.BLACK);

                table = new PdfPTable(2);

                table.SetWidths(new float[] { 0.5f, 2f });

                table.TotalWidth = 340f;

                table.LockedWidth = true;

                table.SpacingBefore = 20f;

                table.HorizontalAlignment = Element.ALIGN_RIGHT;

                //Employee Id

                table.AddCell(PhraseCell(new Phrase("Employee code:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));

                table.AddCell(PhraseCell(new Phrase("000" + dr["EmpID"], FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)), PdfPCell.ALIGN_LEFT));

                cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);

                cell.Colspan = 2;

                cell.PaddingBottom = 10f;

                table.AddCell(cell);

                //Address

                table.AddCell(PhraseCell(new Phrase("Address:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));

                phrase = new Phrase(new Chunk(dr["Address"] + "\n", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));

                //  phrase.Add(new Chunk(dr["City"] + "\n", FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));

                //  phrase.Add(new Chunk(dr["Region"] + " " + dr["Country"] + " " + dr["PostalCode"], FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)));

                table.AddCell(PhraseCell(phrase, PdfPCell.ALIGN_LEFT));

                cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);

                cell.Colspan = 2;

                cell.PaddingBottom = 10f;

                table.AddCell(cell);

                //Date of Birth

                table.AddCell(PhraseCell(new Phrase("Date of Birth:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));

                table.AddCell(PhraseCell(new Phrase(Convert.ToDateTime(dr["BirthDate"]).ToString("dd MMMM, yyyy"), FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)), PdfPCell.ALIGN_LEFT));

                cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);

                cell.Colspan = 2;

                cell.PaddingBottom = 10f;

                table.AddCell(cell);

                //Phone

                table.AddCell(PhraseCell(new Phrase("Phone Number:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));

                table.AddCell(PhraseCell(new Phrase(dr["HomePhone"] + " Ext: " + dr["Extension"], FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)), PdfPCell.ALIGN_LEFT));

                cell = PhraseCell(new Phrase(), PdfPCell.ALIGN_CENTER);

                cell.Colspan = 2;

                cell.PaddingBottom = 10f;

                table.AddCell(cell);

                //Addtional Information

                table.AddCell(PhraseCell(new Phrase("Addtional Information:", FontFactory.GetFont("Arial", 8, Font.BOLD, Color.BLACK)), PdfPCell.ALIGN_LEFT));

                table.AddCell(PhraseCell(new Phrase(dr["Notes"].ToString(), FontFactory.GetFont("Arial", 8, Font.NORMAL, Color.BLACK)), PdfPCell.ALIGN_JUSTIFIED));

                document.Add(table);

                document.Close();

                byte[] bytes = memoryStream.ToArray();

                memoryStream.Close();

                Response.Clear();

                Response.ContentType = "application/pdf";

                Response.AddHeader("Content-Disposition", "attachment; filename=Employee.pdf");

                Response.ContentType = "application/pdf";

                Response.Buffer = true;

                Response.Cache.SetCacheability(HttpCacheability.NoCache);

                Response.BinaryWrite(bytes);

                Response.End();

                Response.Close();

            }

        }

        private static void DrawLine(PdfWriter writer, float x1, float y1, float x2, float y2, Color color)

        {

            PdfContentByte contentByte = writer.DirectContent;

            contentByte.SetColorStroke(color);

            contentByte.MoveTo(x1, y1);

            contentByte.LineTo(x2, y2);

            contentByte.Stroke();

        }

        private static PdfPCell PhraseCell(Phrase phrase, int align)

        {

            PdfPCell cell = new PdfPCell(phrase);

            cell.BorderColor = Color.WHITE;

            cell.VerticalAlignment = PdfCell.ALIGN_TOP;

            cell.HorizontalAlignment = align;

            cell.PaddingBottom = 2f;

            cell.PaddingTop = 0f;

            return cell;

        }

        private static PdfPCell ImageCell(string path, float scale, int align)

        {

            iTextSharp.text.Image image = iTextSharp.text.Image.GetInstance(HttpContext.Current.Server.MapPath(path));

            image.ScalePercent(scale);

            PdfPCell cell = new PdfPCell(image);

            cell.BorderColor = Color.WHITE;

            cell.VerticalAlignment = PdfCell.ALIGN_TOP;

            cell.HorizontalAlignment = align;

            cell.PaddingBottom = 0f;

            cell.PaddingTop = 0f;

            return cell;

        }

Here in this Example we had use iTextSharp.text.pdf namespaces for generating pdf file and bind employee name for generating report based on employee. For generating address, name, employee details, photo, separate line, phone number, employee code, company details, company address for that we have customise here for generating report.

Now run you webpage and select employee for generate details and click generate report for report details.

Author : Umesh Patel

Related Posts