//protected void lnkNewReport_Click(object sender, EventArgs e) //{ // Response.Redirect("frmReportCustomNew.aspx", true); //} protected void btnExportReport_Click(object sender, EventArgs e) { if (this.ddTitle.SelectedValue.ToString() != "") { DataSet dsExistingReport; IReports CustomReport; CustomReport = (IReports)ObjectFactory.CreateInstance("BusinessProcess.Reports.BReports,BusinessProcess.Reports"); dsExistingReport = CustomReport.GetCustomReportData(Convert.ToInt32(this.ddTitle.SelectedValue)); Stream stream = new MemoryStream(); dsExistingReport.WriteXml(stream, XmlWriteMode.WriteSchema); byte[] Buffer; Buffer = new byte[stream.Length]; stream.Position = 0; stream.Read(Buffer, 0, (int)stream.Length); stream.Close(); Response.Clear(); Response.ContentType = "application/xml"; Response.AddHeader("content-disposition", "attachment; filename=Report.xml"); Response.BinaryWrite(Buffer); Response.End(); } }
//protected void lnkNewReport_Click(object sender, EventArgs e) //{ // Response.Redirect("frmReportCustomNew.aspx", true); //} protected void btnExportReport_Click(object sender, EventArgs e) { if (this.ddTitle.SelectedValue.ToString() != "") { DataSet dsExistingReport, dsCustomReport; IReports CustomReport; CustomReport = (IReports)ObjectFactory.CreateInstance("BusinessProcess.Reports.BReports,BusinessProcess.Reports"); dsExistingReport = CustomReport.GetCustomReportData(Convert.ToInt32(this.ddTitle.SelectedValue)); Stream stream = new MemoryStream(); dsExistingReport.WriteXml(stream, XmlWriteMode.WriteSchema); byte[] Buffer; Buffer = new byte[stream.Length]; stream.Position = 0; stream.Read(Buffer, 0, (int)stream.Length); stream.Close(); Response.Clear(); Response.ContentType = "application/xml"; Response.AddHeader("content-disposition", "attachment; filename=Report.xml"); Response.BinaryWrite(Buffer); Response.End(); //DataTable dtReportField = null; //DataTable dtReportFilter = null; //if (dsExistingReport.Tables.Count > 1 && dsExistingReport.Tables[1] != null) //{ // dtReportField = dsExistingReport.Tables[1]; //} //if (dsExistingReport.Tables.Count > 2 && dsExistingReport.Tables[2] != null) //{ // dtReportFilter = dsExistingReport.Tables[2]; //} //DataRow drMstReport; //dsCustomReport = CreateDataSet(); //drMstReport = dsCustomReport.Tables["dtMstReport"].NewRow(); //drMstReport["ReportName"] = dsExistingReport.Tables[0].Rows[0]["ReportName"].ToString(); //drMstReport["Description"] = dsExistingReport.Tables[0].Rows[0]["Description"].ToString(); //drMstReport["Condition"] = dsExistingReport.Tables[0].Rows[0]["Condition"].ToString(); //drMstReport["CategoryId"] = dsExistingReport.Tables[0].Rows[0]["CategoryId"].ToString(); //drMstReport["RptType"] = dsExistingReport.Tables[0].Rows[0]["RptType"].ToString(); //dsCustomReport.Tables["dtMstReport"].Rows.Add(drMstReport); //DataRow drReportFields; //DataRow drReportFilter; //DataView dvFilter; //if (drMstReport["RptType"].ToString() == "DYNAMIC") //{ // if (dtReportField != null) // { // foreach (DataRow dr in dtReportField.Rows) // { // drReportFields = dsCustomReport.Tables["dtlReportFields"].NewRow(); // drReportFields["GroupId"] = Convert.ToInt32(dr["GroupId"]); // drReportFields["FieldId"] = Convert.ToInt32(dr["FieldId"]); // drReportFields["FieldLabel"] = dr["FieldName"].ToString(); // drReportFields["AggregateFunction"] = dr["AggregateFunction"].ToString(); // drReportFields["IsDisplay"] = dr["IsDisplay"]; // drReportFields["Sequence"] = dr["Sequence"]; // drReportFields["Sort"] = dr["Sort"]; // drReportFields["ViewName"] = dr["ViewName"]; // dsCustomReport.Tables["dtlReportFields"].Rows.Add(drReportFields); // //=============================================================================== // dvFilter = new DataView(dtReportFilter, "ReportFieldId=" + dr["ReportFieldId"], "Sequence", DataViewRowState.CurrentRows); // if (dvFilter.Count > 0) // { // for (int i = 0; i < dvFilter.Count; i++) // { // drReportFilter = dsCustomReport.Tables["dtlReportFilter"].NewRow(); // drReportFilter["LinkFieldId"] = Convert.ToInt32(dr["FieldId"]); //Convert.ToInt32(dr["Sequence"]); // drReportFilter["Operator"] = dvFilter[i]["Operator"].ToString(); // drReportFilter["FilterValue"] = dvFilter[i]["FilterValue"].ToString(); // drReportFilter["AndOr"] = dvFilter[i]["AndOr"].ToString(); // drReportFilter["Sequence"] = dvFilter[i]["Sequence"].ToString(); // drReportFilter["Operator1"] = dvFilter[i]["Operator1"].ToString(); // drReportFilter["FilterValue1"] = dvFilter[i]["FilterValue1"].ToString(); // drReportFilter["PanelId"] = Convert.ToInt32(dr["Sequence"]); // drReportFilter["AndOr1"] = dvFilter[i]["AndOr1"].ToString(); // labtest changed // dsCustomReport.Tables["dtlReportFilter"].Rows.Add(drReportFilter); // } // } // //=============================================================================== // } // } //} } }