Crystal Reports for Visual Studio 2013 – Generate PDF Report ( Schedule Job )

Crystal Reports for Visual Studio 2013 – Generate PDF Report ( Schedule Job )

 
   Create DataSet Item under Web Application Project.
   Add TableAdapter on DataSet.
   Select ADO.NET DataSet on Crystal Reports & Design Report Layout.
 
 
   using System.Data;
   using System.Data.SqlClient;
   using CrystalDecisions.CrystalReports.Engine;
   using CrystalDecisions.Shared;
   using System.IO;
 
   static void Main(string[] args)
   {
 
      ReportClass rd = new ReportClass();
 
      rd.FileName = @"..\..\Report.rpt";
 
      rd.Load();
 
      rd.SetDataSource(getDataTable());
 
      if(rd != null){
         rd.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, @".\player.pdf");
      }
 
   }
 
   static DataTable getDataTable()
   {
 
      String connectionString = "Data Source=VMSER001;Initial Catalog=Soccer;Persist Security Info=True;User ID=sa;Password=xxxxxxxx";
      SqlConnection con = new SqlConnection(connectionString);
      con.Open();
 
      String SqlString = "SELECT * FROM PLAYER_VIEW";
 
      SqlCommand cmd = new SqlCommand(SqlString, con);
      SqlDataReader dr = cmd.ExecuteReader();
 
      DataTable dt = new DataTable();
 
      return dt;
 
   }