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