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(); ////////////////////////////////////////////////////// /////////////////////////////////////////////////////// }