public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
TimelineReport rpt = new TimelineReport();
rpt.Site = this.Site;
return(rpt);
}
private void ReportPreview_Load(object sender, EventArgs e)
{
// Copy data to Data Temp
ReportDS dsTemp = new ReportDS();
dsTemp.tbLand.ImportRow(tblReport.tbLand[0]);
// Select data from Database
dbConString.Chk_ConnectionState();
string sqlTmp = "SELECT * FROM uv_Timeline ORDER BY TimeLineDate, EvidenceCode, EvidenceName";
TimelineReport fReport = new TimelineReport();
DataSet Ds = new DataSet();
dbConString.Com = new SqlCommand();
dbConString.Com.CommandType = CommandType.Text;
dbConString.Com.CommandText = sqlTmp;
dbConString.Com.Connection = dbConString.mySQLConn;
SqlCommand cmd = new SqlCommand(sqlTmp, dbConString.mySQLConn);
SqlDataAdapter da = new SqlDataAdapter(cmd);
tblReport.Clear();
da.Fill(tblReport, "uv_Timeline");
da.Dispose();
//// Import data from Data Temp to main dataset
//tblReport.tbLand.ImportRow(dsTemp.tbLand[0]);
fReport.SetDataSource(tblReport);
fReport.SetParameterValue("VillageNo", dsTemp.tbLand[0].VillageNo.ToString());
fReport.SetParameterValue("VillageName", dsTemp.tbLand[0].VillageName.ToString());
fReport.SetParameterValue("SubDistrict", dsTemp.tbLand[0].SubDistrict.ToString());
fReport.SetParameterValue("District", dsTemp.tbLand[0].District.ToString());
fReport.SetParameterValue("Province", dsTemp.tbLand[0].Province.ToString());
crvTimeline.ReportSource = fReport;
}
