protected void btnExcel_Click(object sender, EventArgs e) { System.IO.MemoryStream m_stream = new System.IO.MemoryStream(); rptStackBalance rpt = new rptStackBalance(); GRN_BL objSGRN = new GRN_BL(); rpt.DataSource = objSGRN.GetGRNStackBalanceReport(UserBLL.GetCurrentWarehouse(), new Guid(drpShed.SelectedValue), new Guid(drpInventoryCoordinatorLoad.SelectedValue), new Guid(drpStackNo.SelectedValue.ToString())); rpt.PageSettings.Margins.Top = 0; rpt.PageSettings.Orientation = DataDynamics.ActiveReports.Document.PageOrientation.Landscape; rpt.Run(); if (this.xlsExport1 == null) { this.xlsExport1 = new DataDynamics.ActiveReports.Export.Xls.XlsExport(); } // this.xlsExport1.MinColumnWidth = (float)(0.5); this.xlsExport1.Export(rpt.Document, m_stream); m_stream.Position = 0; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("content-disposition", "inline; filename=MyExport.xls"); Response.BinaryWrite(m_stream.ToArray()); Response.End(); }
private void Viewer_ToolClick(object sender, DataDynamics.ActiveReports.Toolbar.ToolClickEventArgs e) { if (e.Tool.Id == 42) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "Archivos PDF|*.pdf"; dlg.Title = "Guardar reporte como ..."; if (dlg.ShowDialog() == DialogResult.OK) { DataDynamics.ActiveReports.Export.Pdf.PdfExport pdf = new DataDynamics.ActiveReports.Export.Pdf.PdfExport(); pdf.Export(this.Viewer.Document, dlg.FileName.ToString()); } } if (e.Tool.Id == 43) { SaveFileDialog dlg = new SaveFileDialog(); dlg.Filter = "Archivos Excel|*.xls"; dlg.Title = "Guardar reporte como ..."; if (dlg.ShowDialog() == DialogResult.OK) { DataDynamics.ActiveReports.Export.Xls.XlsExport xls = new DataDynamics.ActiveReports.Export.Xls.XlsExport(); xls.Export(this.Viewer.Document, dlg.FileName.ToString()); } } }
private void InitializeComponent() { this.xlsExport1 = new DataDynamics.ActiveReports.Export.Xls.XlsExport(); // // xlsExport1 // this.xlsExport1.Tweak = 0; }
private void viewer_ToolClick(object sender, DataDynamics.ActiveReports.Toolbar.ToolClickEventArgs e) { if (e.Tool.Id == 777) { saveFileDialogForExcelExport.FileName = ""; if (saveFileDialogForExcelExport.ShowDialog() == System.Windows.Forms.DialogResult.OK) { var xlsExport = new DataDynamics.ActiveReports.Export.Xls.XlsExport(); xlsExport.Export(viewer.Document, saveFileDialogForExcelExport.FileName); helper.MsgBox.Info(Properties.Resources.MsgSucceeded); } } }
protected void Button1_Click(object sender, EventArgs e) { System.IO.MemoryStream m_stream = new System.IO.MemoryStream(); GRN_BL objGrn = new GRN_BL(); rptWBServiceProvider rpt = new rptWBServiceProvider(); Guid warehouseId = new Guid(cboWarehouse.SelectedValue); int wbServiceProviderId = cboWBServiceProvider.SelectedIndex == 0 ? -2 : int.Parse(cboWBServiceProvider.SelectedValue); DateTime startDate = string.IsNullOrEmpty(txtStartDate.Text) ? DateTime.Parse("1/1/2010") : DateTime.Parse(txtStartDate.Text); DateTime endDate = string.IsNullOrEmpty(txtEndDate.Text) ? DateTime.Now : DateTime.Parse(txtEndDate.Text); int serviceType = int.Parse(cboServiceType.SelectedValue); DataTable dt = objGrn.GetWBServiceProviderReport(warehouseId, wbServiceProviderId, startDate, endDate, serviceType); decimal sumNumberOfBags, sumNetWeight; int rowsCount = dt.Rows.Count; string NoOfRegords = ""; if (rowsCount == 0) { Messages1.SetMessage("No record found with specified criteria.", WarehouseApplication.Messages.MessageType.Warning); WebViewer1.ClearCachedReport(); return; } else { sumNumberOfBags = decimal.Parse(dt.Compute("Sum(NumberOfBags)", "").ToString()); sumNetWeight = decimal.Parse(dt.Compute("Sum(NetWeight)", "").ToString()); NoOfRegords = rowsCount == 1 ? "1 record found." : rowsCount + " records found."; Messages1.SetMessage(NoOfRegords, WarehouseApplication.Messages.MessageType.Success); rpt.SumNumberOfBags = sumNumberOfBags; rpt.SumNetWeight = sumNetWeight; } rpt.Warehouse = cboWarehouse.SelectedItem.Text; rpt.WBServiceProvider = cboWBServiceProvider.SelectedIndex == 0 ? "All" : cboWBServiceProvider.SelectedItem.Text; rpt.DateFrom = string.IsNullOrEmpty(txtStartDate.Text) ? "No Limit" : txtStartDate.Text; rpt.DateTo = string.IsNullOrEmpty(txtEndDate.Text) ? "Present Date" : txtEndDate.Text; rpt.DataSource = dt; rpt.Run(); if (this.xlsExport1 == null) { this.xlsExport1 = new DataDynamics.ActiveReports.Export.Xls.XlsExport(); } // this.xlsExport1.MinColumnWidth = (float)(0.5); this.xlsExport1.Export(rpt.Document, m_stream); m_stream.Position = 0; Response.ContentType = "application/vnd.ms-excel"; Response.AddHeader("content-disposition", "inline; filename=MyExport.xls"); Response.BinaryWrite(m_stream.ToArray()); Response.End(); }
private void arvMainViwer_ToolClick(object sender, DataDynamics.ActiveReports.Toolbar.ToolClickEventArgs e) { if (e.Tool.Id == 25) { SaveFileDialog saveFileDialog = new SaveFileDialog(); Object RutaDir = Convert.ToString(Environment.CurrentDirectory); saveFileDialog.Filter = "Microsoft Excel (*.xls)|*.xls|Acrobat Reader (*.pdf)|*.pdf|Página Web (*.html)|*.htm"; saveFileDialog.Title = "Exportar a archivo"; saveFileDialog.ShowDialog(); if (saveFileDialog.FileName != "") { try { string Extfile = (saveFileDialog.FileName.Substring(saveFileDialog.FileName.Length - 3, 3)); switch (Extfile.ToUpper()) { case "XLS": DataDynamics.ActiveReports.Export.Xls.XlsExport MyEx = new DataDynamics.ActiveReports.Export.Xls.XlsExport(); MyEx.RemoveVerticalSpace = false; MyEx.DisplayGridLines = true; MyEx.UseCellMerging = false; MyEx.AutoRowHeight = true; MyEx.MinRowHeight = (float)0.1; MyEx.MultiSheet = false; MyEx.Export(this.arvMainViwer.Document, saveFileDialog.FileName); MyEx.Dispose(); break; case "PDF": DataDynamics.ActiveReports.Export.Pdf.PdfExport MyPd = new DataDynamics.ActiveReports.Export.Pdf.PdfExport(); MyPd.Export(this.arvMainViwer.Document, saveFileDialog.FileName); MyPd.Dispose(); break; case "TML": DataDynamics.ActiveReports.Export.Html.HtmlExport MyHtml = new DataDynamics.ActiveReports.Export.Html.HtmlExport(); MyHtml.Export(this.arvMainViwer.Document, saveFileDialog.FileName); MyHtml.Dispose(); break; } } catch (Exception Ex) { throw new Exception(Ex.Message, Ex.InnerException); } } } }