public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptRenwalByDate rpt = new rptRenwalByDate(); rpt.Site = this.Site; return(rpt); }
private void btnShow_Click(object sender, EventArgs e) { try { DateTime from = Convert.ToDateTime(dtpFrom.Text); DateTime to = Convert.ToDateTime(dtpTo.Text); SqlConnection con = new SqlConnection(Community.DBLayer.con_String); con.Open(); string query = richTextBox1.Text; SqlCommand cmd = new SqlCommand(query, con); SqlParameter paraFrom = cmd.Parameters.Add("@From", SqlDbType.DateTime); paraFrom.Value = from; SqlParameter paraTo = cmd.Parameters.Add("@To", SqlDbType.DateTime); paraTo.Value = to; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(); da.SelectCommand = cmd; da.Fill(dt); Reports.Renwal.frmViewer frm = new MCKJ.Reports.Renwal.frmViewer(); Reports.Renwal.rptRenwalByDate rpt = new rptRenwalByDate(); frm.crystalReportViewer1.ReportSource = rpt; rpt.SetDataSource(dt); rpt.SetParameterValue("From", from.Date.ToShortDateString()); rpt.SetParameterValue("To", to.Date.ToShortDateString()); frm.Show(); con.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }