private void ShowReport() { OperationResult objOperationResult = new OperationResult(); // Cabecera var headerRoadMap = _calendarBL.GetHeaderRoadMap(_calendarId); // Detalle //var detailRoadMap = _serviceBL.GetServiceComponentsRoadMap(ref objOperationResult, _serviceId); var detailRoadMap = _serviceBL.GetServiceComponentsByCategory(ref objOperationResult, _serviceId); var rp = new Reports.crRoadMapCompleta(); DataSet ds = new DataSet(); DataTable dtHeader = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(headerRoadMap); DataTable dtDetail = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(detailRoadMap); dtHeader.TableName = "dtHeaderRoadMap"; dtDetail.TableName = "dtDetailRoadMap"; ds.Tables.Add(dtHeader); ds.Tables.Add(dtDetail); rp.SetDataSource(ds); crystalReportViewer1.ReportSource = rp; crystalReportViewer1.Show(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ReportDocument rp = new ReportDocument(); List <string> _filesNameToMerge = new List <string>(); List <MyListWeb> ListaServicios = (List <MyListWeb>)Session["objLista"]; if (ListaServicios == null) { Alert.Show("Seleccione un registro"); return; } else { foreach (var item in ListaServicios) { OperationResult objOperationResult = new OperationResult(); var headerRoadMap = _calendarBL.GetHeaderRoadMap(item.CalendarId); var detailRoadMap = _serviceBL.GetServiceComponentsByCategoryExceptLab(ref objOperationResult, item.IdServicio); DataSet ds = new DataSet(); DataTable dtHeader = Sigesoft.Server.WebClientAdmin.UI.Utils.ConvertToDatatable(headerRoadMap); DataTable dtDetail = Sigesoft.Server.WebClientAdmin.UI.Utils.ConvertToDatatable(detailRoadMap); dtHeader.TableName = "dtHeaderRoadMap"; dtDetail.TableName = "dtDetailRoadMap"; ds.Tables.Add(dtHeader); ds.Tables.Add(dtDetail); rp.Load(Server.MapPath("crRoadMap.rpt")); rp.SetDataSource(ds); var ruta = Server.MapPath("files/HojaRuta-" + item.IdServicio.ToString() + ".pdf"); _filesNameToMerge.Add(ruta); rp.ExportToDisk(ExportFormatType.PortableDocFormat, ruta); } if (ListaServicios.Count != 0) { _mergeExPDF.FilesName = _filesNameToMerge; string Dif = Guid.NewGuid().ToString(); string NewPath = Server.MapPath("files/" + Dif + ".pdf"); _mergeExPDF.DestinationFile = NewPath; _mergeExPDF.Execute(); ShowPdf1.FilePath = "files/" + Dif + ".pdf"; } } } }
private void frmConsentimientoHojaRuta_Load(object sender, EventArgs e) { using (new LoadingClass.PleaseWait(this.Location, "Generando...")) { crConsentimientoHojaRuta rp = null; rp = new Reports.crConsentimientoHojaRuta(); //Hoja de Ruta OperationResult objOperationResult = new OperationResult(); // Cabecera var headerRoadMap = _calendarBL.GetHeaderRoadMap(_calendarId); // Detalle var detailRoadMap = _serviceBL.GetServiceComponentsByCategoryExceptLab(ref objOperationResult, _serviceId); DataSet ds = new DataSet(); DataTable dtHeader = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(headerRoadMap); DataTable dtDetail = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(detailRoadMap); dtHeader.TableName = "dtHeaderRoadMap"; dtDetail.TableName = "dtDetailRoadMap"; ds.Tables.Add(dtHeader); ds.Tables.Add(dtDetail); rp.PrintOptions.PaperOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape; rp.Subreports["crRoadMap.rpt"].SetDataSource(ds); rp.DetailSection1.SectionFormat.EnableSuppress = false; ////Consentimiento var aptitudeCertificate = new PacientBL().GetReportConsentimiento(_serviceId); DataSet ds1 = new DataSet(); DataTable dt = Sigesoft.Node.WinClient.BLL.Utils.ConvertToDatatable(aptitudeCertificate); dt.TableName = "dtConsentimiento"; ds1.Tables.Add(dt); rp.Subreports["crConsentimiento.rpt"].SetDataSource(ds1); rp.Section3.SectionFormat.EnableSuppress = false; crystalReportViewer1.EnableDrillDown = false; var Path = Application.StartupPath; rp.ExportToDisk(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat, Path + @"\Temp\Reporte.pdf"); crystalReportViewer1.ReportSource = rp; crystalReportViewer1.Show(); } }