<< Email Template using C# | Did you know.. How to download file from web service using JavaScript or Jquery? >>

MS Chart Controls to PDF with iTextSharp using XML Template

by Farooq Kaiser 10. February 2010 05:45

In this article, i will examined how to build reports with ItextSharp PDF control and Ms Chart controls using XML template. The Xml template gives us freedom to change the contents without having to recompile and deploy the application again. Here is our sample report in XML template.

<?xml version="1.0" encoding="utf-8" ?>

<itext>

<paragraph font="Verdan" size="13.0" fontstyle="bold" align="Default" red="255" green="0" blue="0">My first Report</paragraph>

<paragraph font="Verdan" size="8.0" align="Default">

  <table columns="2" width="60%" align="Left" cellpadding="3" cellspacing="0" widths="50;50" borderwidth="0">

    <row>

      <cell borderwidth="0" backgroundcolor="#FF0000" horizontalalign="Default" verticalalign="Default" header="true" >

        <paragraph font="Verdan" size="9.0" fontstyle="bold" leading="10" align="Default" red="255" green="255" blue="255">

          Header Column1

        </paragraph>

      </cell>

      <cell borderwidth="0" backgroundcolor="#FF0000" horizontalalign="Default" verticalalign="Default" >

        <paragraph  font="Verdan" size="9.0" fontstyle="bold" align="Default" red="255" green="255" blue="255">

          Header Column2

        </paragraph>

      </cell>

    </row>

    <row>

      <cell borderwidth="0.5" horizontalalign="Default" verticalalign="Default" red="255" green="0" blue="0">

        <paragraph  font="Verdan" size="8.0" align="Default" leading="10">

          Column1 Row1 data

        </paragraph>

      </cell>

      <cell borderwidth="0.5" horizontalalign="Default" verticalalign="Default" red="255" green="0" blue="0">

        <paragraph  font="Verdan" size="9.0" fontstyle="bold" align="Default" leading="10">

          Column2 Row1 data

        </paragraph>

      </cell>

    </row>

    <row>

      <cell borderwidth="0.5" horizontalalign="Default" verticalalign="Default" red="255" green="0" blue="0">

        <paragraph  font="Verdan" size="8.0" align="Default" leading="10">

          Column1 Row2 data

        </paragraph>

      </cell>

      <cell borderwidth="0.5" horizontalalign="Default" verticalalign="Default" red="255" green="0" blue="0">

        <paragraph  font="Verdan" size="9.0" fontstyle="bold" align="Default" leading="10">

          Column2 Row2 data

        </paragraph>

      </cell>

    </row>

  </table >

</paragraph>

</itext>

Here is our C# code that will generate the PDF.

XmlDocument xdox = new XmlDocument();

xdox.Load(XMLFile);

Document document = new Document();

PdfWriter.GetInstance(document, new FileStream(OutPutFileName, FileMode.Create));

ITextHandler xmlHandler = new ITextHandler(document);

xmlHandler.Parse(xdox);

Here is our PDF output.

Now, i want to implement chart control in our PDF, so here is our XML template.

<?xml version="1.0" encoding="utf-8" ?>

<itext>

<paragraph font="Verdan" size="13.0" fontstyle="bold" align="Default" red="255" green="0" blue="0">My first Report</paragraph>

<paragraph font="Verdan" size="8.0" align="Default">

  <table columns="2" width="60%" align="Left" cellpadding="3" cellspacing="0" widths="50;50" borderwidth="0">

    <row>

      <cell borderwidth="0" backgroundcolor="#FF0000" horizontalalign="Default" verticalalign="Default" header="true" >

        <paragraph font="Verdan" size="9.0" fontstyle="bold" leading="10" align="Default" red="255" green="255" blue="255">

          Header Column1

        </paragraph>

      </cell>

      <cell borderwidth="0" backgroundcolor="#FF0000" horizontalalign="Default" verticalalign="Default" >

        <paragraph  font="Verdan" size="9.0" fontstyle="bold" align="Default" red="255" green="255" blue="255">

          Header Column2

        </paragraph>

      </cell>

    </row>

    <row>

      <cell borderwidth="0.5" horizontalalign="Default" verticalalign="Default" red="255" green="0" blue="0">

        <paragraph  font="Verdan" size="8.0" align="Default" leading="10">

          Column1 Row1 data

        </paragraph>

      </cell>

      <cell borderwidth="0.5" horizontalalign="Default" verticalalign="Default" red="255" green="0" blue="0">

        <paragraph  font="Verdan" size="9.0" fontstyle="bold" align="Default" leading="10">

          Column2 Row1 data

        </paragraph>

      </cell>

    </row>

    <row>

      <cell borderwidth="0.5" horizontalalign="Default" verticalalign="Default" red="255" green="0" blue="0">

        <paragraph  font="Verdan" size="8.0" align="Default" leading="10">

          Column1 Row2 data

        </paragraph>

      </cell>

      <cell borderwidth="0.5" horizontalalign="Default" verticalalign="Default" red="255" green="0" blue="0">

        <paragraph  font="Verdan" size="9.0" fontstyle="bold" align="Default" leading="10">

          Column2 Row2 data

        </paragraph>

      </cell>

    </row>

  </table >

</paragraph>

  <paragraph font="Verdan" size="7.0"  align="Default">

    <image url="images\Chart1.jpg" align="left" plainwidth="180" plainheight="140" />

  </paragraph>

</itext>

and, here is our c# code to generate Chart using ms chart control.

private static void PieChart()

      {

          try

          {

              Chart chart1 = new Chart();

  

              Series series1 = new Series();

  

              ChartArea chartArea1 = new ChartArea();

  

              chartArea1.Name = "Default";

              series1.Name = "Default";

  

              chart1.Series.Add(series1);

  

              double[] yValues = { 65.62, 75.54, 60.45, 55.73, 70.42 };

              string[] xValues = { "France", "Canada", "UK", "USA", "Italy" };

              chart1.Series["Default"].Points.DataBindXY(xValues, yValues);        

  

              // Set Doughnut chart type

              chart1.Series["Default"].ChartType = SeriesChartType.Pie;

  

              // Set labels style

              chart1.Series["Default"]["PieLabelStyle"] = "Outside";

  

              // Set Doughnut radius percentage

              chart1.Series["Default"]["DoughnutRadius"] = "30";

  

              // Explode data point with label "Italy"

              chart1.Series["Default"].Points[1]["Exploded"] = "true";

  

              // Set drawing style

              chart1.Series["Default"]["PieDrawingStyle"] = "SoftEdge";

  

              chart1.Size = new System.Drawing.Size(412, 296);

              chart1.TabIndex = 0;

  

              chart1.ChartAreas.Add(chartArea1);

              // Enable 3D

              chart1.ChartAreas["Default"].Area3DStyle.Enable3D = true;

  

              chartArea1.Area3DStyle.IsClustered = true;

              chartArea1.Area3DStyle.IsRightAngleAxes = false;

              chartArea1.Area3DStyle.Perspective = 10;

              chartArea1.Area3DStyle.PointGapDepth = 0;

              chartArea1.Area3DStyle.Rotation = 0;

              chartArea1.Area3DStyle.WallWidth = 0;

              chartArea1.AxisX.LabelStyle.Font = new System.Drawing.Font("Trebuchet MS", 8.25F, System.Drawing.FontStyle.Bold);

              chartArea1.AxisX.LineColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));

              chartArea1.AxisX.MajorGrid.LineColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));

              chartArea1.AxisY.LabelStyle.Font = new System.Drawing.Font("Trebuchet MS", 8.25F, System.Drawing.FontStyle.Bold);

              chartArea1.AxisY.LineColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));

              chartArea1.AxisY.MajorGrid.LineColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));

              chartArea1.BackColor = System.Drawing.Color.Transparent;

              chartArea1.BackSecondaryColor = System.Drawing.Color.Transparent;

              chartArea1.BorderColor = System.Drawing.Color.FromArgb(((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))), ((int)(((byte)(64)))));

              chartArea1.BorderWidth = 0;

              chartArea1.Name = "Default";

              chartArea1.ShadowColor = System.Drawing.Color.Transparent;

           

              chart1.SaveImage(@"images\Chart1.jpg", ChartImageFormat.Jpeg);

          }

          catch (Exception ex)

          { 

          

          }

  

  

      }

and, here is our PDF output.

Summary

In this article, we examined how to build reports without using any third party components.

Currently rated 4.3 by 6 people

Currently 4.333333/5 Stars.
1
2
3
4
5

Tags: .net, c#, xml, reports, pdf, chart

Email Template using C# In this article, i will examined how to build template to store email data such as body and subjec...Populating drop down list with XML in C# Today, i will show you how to populate drop down list with xml data. Let's say we hav...How to improve the performance of ASP.NET MVC web application In this article, i will examine how you can improve the performance of an ASP.NET MVC application ...

MS Chart Controls to PDF with iTextSharp using XML Template

Related posts

Comments