public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { rptBirthReg rpt = new rptBirthReg(); rpt.Site = this.Site; return(rpt); }
private void rptBirth() { try { SqlConnection conn = new SqlConnection(DBLayer.CON_string); SqlCommand cmd = new SqlCommand(richTextBox1.Text); cmd.Connection = conn; cmd.CommandType = CommandType.Text; SqlParameter paraStartDate = cmd.Parameters.Add("@FromDate", SqlDbType.DateTime); paraStartDate.Value = Convert.ToDateTime(dateTimePicker1.Text); SqlParameter paraEndDate = cmd.Parameters.Add("@ToDate", SqlDbType.DateTime); paraEndDate.Value = Convert.ToDateTime(dateTimePicker2.Text); SqlDataAdapter sda = new SqlDataAdapter(cmd); DataTable aaa = new DataTable(); sda.Fill(aaa); MCKJ.Reports.Donation.frmViewer frm = new MCKJ.Reports.Donation.frmViewer(); Reports.BirthDeath.rptBirthReg rpt = new rptBirthReg(); rpt.SetDataSource(aaa); rpt.SetParameterValue("fromDate", Convert.ToDateTime(dateTimePicker1.Text)); rpt.SetParameterValue("toDate", Convert.ToDateTime(dateTimePicker2.Text)); frm.crystalReportViewer1.ReportSource = rpt; //frm.Text = "Purchase Bill"; frm.Show(); conn.Close(); } catch (Exception exceptionparamter) { MessageBox.Show("Unable to view report!\n\n" + exceptionparamter.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }