private void Frm_ArrearListRep_Load(object sender, EventArgs e)
{
string sql = "Select * From Temp_CityArrear ORDER BY CustomerPosition";
DataTable dt = SQLUtl.Query(sql).Tables["dataSet"];
ArrearListRep arrearListRep = new ArrearListRep();
arrearListRep.SetDataSource(dt);
crystalReportViewer1.ReportSource = arrearListRep;
TextObject txtMonth = (TextObject)arrearListRep.ReportDefinition.ReportObjects["txtMonth"];
txtMonth.Text = month;
TextObject txtVolumNo = (TextObject)arrearListRep.ReportDefinition.ReportObjects["txtVolumeNo"];
txtVolumNo.Text = volumNo;
TextObject txtPeople = (TextObject)arrearListRep.ReportDefinition.ReportObjects["txtPeople"];
txtPeople.Text = Constant.LoginUser.UserName;
}
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
ArrearListRep rpt = new ArrearListRep();
rpt.Site = this.Site;
return rpt;
}