public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
EmpAllTransRpt rpt = new EmpAllTransRpt();
rpt.Site = this.Site;
return(rpt);
}
private void BtnPrintPreview_Click(object sender, EventArgs e)
{
//DataTable dt = new DataTable();
string sort = "";
if (radioButton1.Checked)
{
sort = "Order by [Employee Name],[Transaction Date],Time";
}
if (radioButton2.Checked)
{
sort = "Order by [Card Number],[Transaction Date],Time";
}
if (radioButton3.Checked)
{
sort = "Order by [Transaction Date],Time";
}
if (radioButton4.Checked)
{
sort = "Order by Department,[Card Number],[Transaction Date],Time";
}
_cmd = new SqlCommand(Str + sort, frmMainForm._MasterCon);
//Str = "select [Employee Name] ,[Card Number],[Transaction Date],Time,Place,Job,Department from VTransactions " + FilterString;
_da = new SqlDataAdapter(_cmd);
_Dt = new DataTable();
_Dt.Reset();
_da.Fill(_Dt);
//////////////////////////////////////////////////////
EmpAllTransRpt EmpTransRpt = new EmpAllTransRpt();
//EmpTransRptAr EmpTransRptAr = new EmpTransRptAr();
/////////////////////////////////////////////////////////////////////
frmReportViewer2 Viewer = new frmReportViewer2();
if (_Dt.Rows.Count == 0)
{
MessageBox.Show("Message_No_Records", "", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//////////////////////////////////////////////////////
EmpTransRpt.Database.Tables["VTransactions"].SetDataSource(_Dt);
EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_From.ParameterFieldName, dtpDateFrom.Text);
EmpTransRpt.SetParameterValue(EmpTransRpt.Parameter_To.ParameterFieldName, dtpDateTo.Text);
Viewer.crystalReportViewer1.ReportSource = EmpTransRpt;
Viewer.ShowDialog();
//////////////////////////////////////////////////////
///////////////////////////////////////////////////////
}
