public ActionResult DescargarReporteEmpleado(int codigo, string algo) //public ActionResult DescargarReporteEmpleado(int codigo) { try { var rptH = new ReportClass(); rptH.FileName = Server.MapPath("/Reportes/EmpleadoReporte1.rpt"); rptH.Load(); // por parametro rptH.SetParameterValue("DptoId", codigo); //rptH.SetParameterValue("ParamAlgo", algo); // Report connection var connInfo = CrystalReportsCnn.GetConnectionInfo(); TableLogOnInfo logonInfo = new TableLogOnInfo(); Tables tables; tables = rptH.Database.Tables; foreach (Table table in tables) { logonInfo = table.LogOnInfo; logonInfo.ConnectionInfo = connInfo; table.ApplyLogOnInfo(logonInfo); } Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); // Descargar en PDF Stream stream = rptH.ExportToStream(ExportFormatType.PortableDocFormat); rptH.Dispose(); rptH.Close(); return(new FileStreamResult(stream, "application/pdf")); // Descargar en Excel //Stream stream = rptH.ExportToStream(ExportFormatType.Excel); //stream.Seek(0, SeekOrigin.Begin); //return File(stream, "application/vnd.ms-excel", "empleadoRpt.xls"); } catch (Exception ex) { return(Json(new { ok = false, msg = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DescargarReporteAsignacionesExcel(int?id) { try { var rptH = new ReportClass(); rptH.FileName = Server.MapPath("/Reportes/AsignacionReport.rpt"); rptH.Load(); if (id == null) { rptH.SetDataSource(ProyectoCN.ListarAsignaciones()); } else { rptH.SetDataSource(ProyectoCN.ListarAsignaciones(id.Value)); } // Report connection var connInfo = CrystalReportsCnn.GetConnectionInfo(); TableLogOnInfo logonInfo = new TableLogOnInfo(); Tables tables; tables = rptH.Database.Tables; foreach (Table table in tables) { logonInfo = table.LogOnInfo; logonInfo.ConnectionInfo = connInfo; table.ApplyLogOnInfo(logonInfo); } Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); // Descargar en Excel Stream stream = rptH.ExportToStream(ExportFormatType.Excel); stream.Seek(0, SeekOrigin.Begin); return(File(stream, "application/vnd.ms-excel", "asignacionRpt.xls")); } catch (Exception ex) { return(Json(new { ok = false, msg = ex.Message }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DescargarReporteEmpleado() { try { var reportE = new ReportClass(); reportE.FileName = Server.MapPath("/Reports/EmpleadoOLE_DBReport.rpt"); reportE.Load(); //report connection var connInfo = CrystalReportsCnn.GetConnectionInfo(); TableLogOnInfo logonInfo = new TableLogOnInfo(); Tables tables; tables = reportE.Database.Tables; foreach (Table table in tables) { logonInfo = table.LogOnInfo; logonInfo.ConnectionInfo = connInfo; table.ApplyLogOnInfo(logonInfo); } Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); //pdf Stream reportStream = reportE.ExportToStream(ExportFormatType.PortableDocFormat); reportE.Dispose(); reportE.Close(); return(new FileStreamResult(reportStream, "application/pdf ")); //Exel //Stream reportStream = reportE.ExportToStream(ExportFormatType.Excel); //reportStream.Seek(0, SeekOrigin.Begin); //return File(reportStream, "application/vnd.ms-exel","Empleados.xls"); } catch (Exception ex) { throw; } }