public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptFamilyCard rpt = new rptFamilyCard();
rpt.Site = this.Site;
return(rpt);
}
private void rpt_Area()
{
try
{
if (cmbSearch.Text == "")
{
MessageBox.Show("Please Fill in the Field!!", "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
}
else
{
string X = cmbSearch.Text;
SqlConnection conn = new SqlConnection(Community.DBLayer.con_String);
conn.Open();
SqlCommand cmd = new SqlCommand("Select * from tblFamily WHERE Area = '" + X + "'Order By tblFamily.FCardNo asc", conn);
DataTable dt = new DataTable();
cmd.CommandType = CommandType.Text;
//SqlParameter paraID = cmd.Parameters.Add("@FCardNo",SqlDbType.VarChar , 50);
//paraID.Value = X;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
da.Fill(dt);
Reports.Family_Card.frmViewer frm = new frmViewer();
Reports.Family_Card.rptFamilyCard rpt = new rptFamilyCard();
frm.crystalReportViewer1.ReportSource = rpt;
rpt.SetDataSource(dt);
rpt.SetParameterValue("Filter", "Family Cards of Area '" + X + "'");
frm.Show();
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("AN unknown error occured \n\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}