protected void btn_ShowReport_Click(object sender, EventArgs e) { img_ExportToExcel1.Visible = false; if (ddl_Term.SelectedValue == "0") { RadWindowManager1.RadAlert("لطفا ترم را انتخاب کنید", 0, 100, "پیام", ""); } else { if (txt_did.Text == string.Empty) { txt_did.Text = "0"; } if (txt_CodeOstad.Text == string.Empty) { txt_CodeOstad.Text = "0"; } System.Data.DataTable dt = FRB.GetAcceptMark(ddl_Term.SelectedValue, int.Parse(txt_did.Text), int.Parse(txt_CodeOstad.Text), Convert.ToInt32(ddlDanesh.SelectedValue)); if (dt.Rows.Count == 0) { RadWindowManager1.RadAlert("رکوردی وجود ندارد", 100, 0, "پیام", ""); } else { //Report img_ExportToExcel1.Visible = true; StiWebViewer1.Visible = true; this.StiWebViewer1.ResetReport(); StiReport rpt = new StiReport(); rpt.Load(Server.MapPath("../Report/ReportFinal.mrt")); rpt.ReportCacheMode = StiReportCacheMode.On; rpt.Dictionary.Databases.Clear(); rpt.Dictionary.Databases.Add(new StiSqlDatabase("Connection1", CB.ReportConnection.ToString())); rpt.Compile(); rpt.CompiledReport.DataSources["[Faculty].[SP_ReportAcceptMark]"].Parameters["@Term"].ParameterValue = ddl_Term.SelectedValue; rpt.CompiledReport.DataSources["[Faculty].[SP_ReportAcceptMark]"].Parameters["@CodeOstad"].ParameterValue = int.Parse(txt_CodeOstad.Text); rpt.CompiledReport.DataSources["[Faculty].[SP_ReportAcceptMark]"].Parameters["@Did"].ParameterValue = int.Parse(txt_did.Text); rpt.CompiledReport.DataSources["[Faculty].[SP_ReportAcceptMark]"].Parameters["@daneshID"].ParameterValue = int.Parse(ddlDanesh.SelectedValue); rpt.RegData(dt); //rpt.Dictionary.Synchronize(); //rpt.Show(); StiWebViewer1.Report = rpt; StiWebViewer1.Visible = true; } if (txt_did.Text == "0") { txt_did.Text = string.Empty; } if (txt_CodeOstad.Text == "0") { txt_CodeOstad.Text = string.Empty; } } }