protected void btnShow_Click(object sender, EventArgs e) { int month = Convert.ToInt32(dllMonth.SelectedValue); int year = Convert.ToInt32(ddlYear.SelectedValue); int dep = Convert.ToInt32(ddlDep.SelectedValue); using (ClubDBEntities club = new ClubDBEntities()) { var result = club.getEandIReport(month, year, dep); if (result.Count() > 0) { EandICR report = new EandICR(); report.Load(Server.MapPath("EandICR.rpt")); report.SetDataSource(result); CrystalReportViewer1.ReportSource = report; lblError.Visible = false; btnPrint.Visible = true; } else { lblError.Visible = true; lblError.Text = "لايوجد بيانات لعرضها"; btnPrint.Visible = false; } pnlData.Visible = true; } }