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; } |