public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
rptType_Members rpt = new rptType_Members();
rpt.Site = this.Site;
return(rpt);
}
private void rpt_BGroup()
{
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 *,tblFamily.Sign,tblFamily.Nukh,tblFamily.City,tblFamily.Area,tblFamily.Country from tblFamilyMember INNER JOIN tblFamily ON tblFamilyMember.FCardNo = tblFamily.FCardNo WHERE tblFamilyMember.BloodGroup = '" + 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.Members.frmViewer frm = new frmViewer();
Reports.Members.rptType_Members rpt = new rptType_Members();
frm.crystalReportViewer1.ReportSource = rpt;
rpt.SetDataSource(dt);
rpt.SetParameterValue("Filter", cmbSearch.Text + " Blood Group Members");
frm.Show();
conn.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("AN unknown error occured \n\n" + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
