private void ImprimirReporte() { string Carrera = ddlCarrera.SelectedItem.ToString(); string Formato = ddlFormato.SelectedItem.ToString(); string nombre = ddlCategoria.SelectedItem.ToString(); nombre += " " + ddlReporte.SelectedItem.ToString(); if (Carrera.Equals("TODAS")) { if (ddlCategoria.SelectedIndex != 2) { nombre += " DE TODAS LAS CARRERAS"; } } else { if (ddlCategoria.SelectedIndex != 2) { nombre += " DE " + Carrera; } } if (ddlCategoria.SelectedIndex == 2) { nombre += ddlPeriodo.SelectedItem.Text; } switch (Formato) { case "PDF": nombre += ".pdf"; break; case "WORD": nombre += ".doc"; break; case "EXCEL": nombre += ".xls"; break; } LocalReport report = new LocalReport(); ConeccionesBD Consulta = new ConeccionesBD(); ReportDataSource RDS = new ReportDataSource(); if (ddlCategoria.SelectedIndex == 0) { if (ddlReporte.SelectedIndex == 0) { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { report.ReportPath = "Reportes/NuevoIngresoPorSexo.rdlc"; SEDCEdatasetTableAdapters.NUEVO_INGRESO_POR_SEXOTableAdapter MC = new SEDCEdatasetTableAdapters.NUEVO_INGRESO_POR_SEXOTableAdapter(); MC.Fill(Consulta.NuevoIngresoPorSexo()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.NuevoIngresoPorSexo(); } else { report.ReportPath = "Reportes/NuevoIngresoPorSexo.rdlc"; SEDCEdatasetTableAdapters.NUEVO_INGRESO_POR_SEXO_CARRERA_ESPECIFICATableAdapter MC = new SEDCEdatasetTableAdapters.NUEVO_INGRESO_POR_SEXO_CARRERA_ESPECIFICATableAdapter(); MC.Fill(Consulta.NuevoIngresoPorSexoCarreraEspeficica(Carrera), Carrera); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.NuevoIngresoPorSexoCarreraEspeficica(Carrera); } } else { if (ddlReporte.SelectedIndex == 1) { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { report.ReportPath = "Reportes/NuevoIngresoPorEdad.rdlc"; SEDCEdatasetTableAdapters.NUEVO_INGRESO_POR_EDADTableAdapter MC = new SEDCEdatasetTableAdapters.NUEVO_INGRESO_POR_EDADTableAdapter(); MC.Fill(Consulta.NuevoIngresoPorEdad()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.NuevoIngresoPorEdad(); } else { report.ReportPath = "Reportes/NuevoIngresoPorEdad.rdlc"; SEDCEdatasetTableAdapters.NUEVO_INGRESO_POR_EDAD_CARRERA_ESPECIFICATableAdapter MC = new SEDCEdatasetTableAdapters.NUEVO_INGRESO_POR_EDAD_CARRERA_ESPECIFICATableAdapter(); MC.Fill(Consulta.NuevoIngresoPorEdadCarreraEspeficica(Carrera), Carrera); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.NuevoIngresoPorEdadCarreraEspeficica(Carrera); } } else { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { //PROCEDENCIA POR CARRERA TODAS } else { //PROCEDENCIA POR CARRERA ESPECIFICA } } } } else { if (ddlCategoria.SelectedIndex == 1) { if (ddlReporte.SelectedIndex == 0) { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { report.ReportPath = "Reportes/MatriculaTotalDiscapacidad.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_DISCAPACIDADTableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_DISCAPACIDADTableAdapter(); MC.Fill(Consulta.MatriculaTotalDiscapacidad()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalDiscapacidad(); } else { report.ReportPath = "Reportes/MatriculaTotalDiscapacidad.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_DISCAPACIDAD_CARRERA_ESPECIFICATableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_DISCAPACIDAD_CARRERA_ESPECIFICATableAdapter(); MC.Fill(Consulta.MatriculaTotalDiscapacidadCarreraEspecifica(Carrera), Carrera); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalDiscapacidadCarreraEspecifica(Carrera); } } else { if (ddlReporte.SelectedIndex == 1) { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { report.ReportPath = "Reportes/MatriculaTotalPorSexo.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_POR_SEXOTableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_POR_SEXOTableAdapter(); MC.Fill(Consulta.MatriculaTotalSexo()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalSexo(); } else { report.ReportPath = "Reportes/MatriculaTotalPorSexo.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_POR_SEXO_CARRERA_ESPECIFICATableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_POR_SEXO_CARRERA_ESPECIFICATableAdapter(); MC.Fill(Consulta.MatriculaTotalSexoCarreraEspecifica(Carrera), Carrera); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalSexoCarreraEspecifica(Carrera); } } else { if (ddlReporte.SelectedIndex == 2) { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { report.ReportPath = "Reportes/MatriculaTotalPorEdad.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_POR_EDADTableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_POR_EDADTableAdapter(); MC.Fill(Consulta.MatriculaTotalEdad()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalEdad(); } else { report.ReportPath = "Reportes/MatriculaTotalPorEdad.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_POR_EDAD_CARRERA_ESPECIFICATableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_POR_EDAD_CARRERA_ESPECIFICATableAdapter(); MC.Fill(Consulta.MatriculaTotalEdadCarreraEspecifica(Carrera), Carrera); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalEdadCarreraEspecifica(Carrera); } } else { if (ddlReporte.SelectedIndex == 3) { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { report.ReportPath = "Reportes/MatriculaTotalSemestre.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_SEMESTRETableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_SEMESTRETableAdapter(); MC.Fill(Consulta.MatriculaTotalSemestre()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalSemestre(); } else { report.ReportPath = "Reportes/MatriculaTotalSemestre.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_SEMESTRE_CARRERA_ESPECIFICATableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_SEMESTRE_CARRERA_ESPECIFICATableAdapter(); MC.Fill(Consulta.MatriculaTotalSemestreCarreraEspecifica(Carrera), Carrera); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalSemestreCarreraEspecifica(Carrera); } } else { if (ddlReporte.SelectedIndex == 4) { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { report.ReportPath = "Reportes/MatriculaTotalPromedio.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_PROMEDIOTableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_PROMEDIOTableAdapter(); MC.Fill(Consulta.MatriculaTotalPromedio()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalPromedio(); } else { report.ReportPath = "Reportes/MatriculaTotalPromedio.rdlc"; SEDCEdatasetTableAdapters.MATRICULA_TOTAL_PROMEDIO_CARRERA_ESPECIFICATableAdapter MC = new SEDCEdatasetTableAdapters.MATRICULA_TOTAL_PROMEDIO_CARRERA_ESPECIFICATableAdapter(); MC.Fill(Consulta.MatriculaTotalPromedioCarreraEspecifica(Carrera), Carrera); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.MatriculaTotalPromedioCarreraEspecifica(Carrera); } } else { if (ddlCarrera.SelectedItem.ToString().Equals("TODAS")) { //Alumnos extranjeros TT.TT } else { } } } } } } } else { if (ddlReporte.SelectedIndex == 0) { if (ddlPeriodo.SelectedIndex == 0) { report.ReportPath = "Reportes/EGRESADOS20102.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20102TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20102TableAdapter(); MC.Fill(Consulta.Egresados20102()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20102(); } else { if (ddlPeriodo.SelectedIndex == 1) { report.ReportPath = "Reportes/EGRESADOS20111.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20111TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20111TableAdapter(); MC.Fill(Consulta.Egresados20111()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20111(); } else { if (ddlPeriodo.SelectedIndex == 2) { report.ReportPath = "Reportes/EGRESADOS20112.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20112TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20112TableAdapter(); MC.Fill(Consulta.Egresados20112()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20112(); } else { if (ddlPeriodo.SelectedIndex == 3) { report.ReportPath = "Reportes/EGRESADOS20121.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20121TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20121TableAdapter(); MC.Fill(Consulta.Egresados20121()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20121(); } else { if (ddlPeriodo.SelectedIndex == 4) { report.ReportPath = "Reportes/EGRESADOS20122.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20122TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20122TableAdapter(); MC.Fill(Consulta.Egresados20122()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20122(); } else { if (ddlPeriodo.SelectedIndex == 5) { report.ReportPath = "Reportes/EGRESADOS20131.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20131TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20131TableAdapter(); MC.Fill(Consulta.Egresados20131()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20131(); } else { if (ddlPeriodo.SelectedIndex == 6) { report.ReportPath = "Reportes/EGRESADOS20132.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20132TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20132TableAdapter(); MC.Fill(Consulta.Egresados20132()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20132(); } else { if (ddlPeriodo.SelectedIndex == 7) { report.ReportPath = "Reportes/EGRESADOS20141.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20141TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20141TableAdapter(); MC.Fill(Consulta.Egresados20141()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20141(); } else { report.ReportPath = "Reportes/EGRESADOS20142.rdlc"; SEDCEdatasetTableAdapters.EGRESADOS_20142TableAdapter MC = new SEDCEdatasetTableAdapters.EGRESADOS_20142TableAdapter(); MC.Fill(Consulta.Egresados20142()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.Egresados20142(); } } } } } } } } } else { if (ddlPeriodo.SelectedIndex == 0) { if (ddlCarrera.SelectedItem.Text == "TODAS") { report.ReportPath = "Reportes/INDICEDEREPROBACION20171.rdlc"; SEDCEdatasetTableAdapters.INDICE_DE_REPROBACION_20171TableAdapter MC = new SEDCEdatasetTableAdapters.INDICE_DE_REPROBACION_20171TableAdapter(); MC.Fill(Consulta.IndiceReprobacion20171()); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.IndiceReprobacion20171(); } else { report.ReportPath = "Reportes/INDICEDEREPROBACION20171.rdlc"; SEDCEdatasetTableAdapters.INDICE_DE_REPROBACION_20171_CARRERATableAdapter MC = new SEDCEdatasetTableAdapters.INDICE_DE_REPROBACION_20171_CARRERATableAdapter(); MC.Fill(Consulta.IndiceReprobacion20171Carrera(Carrera), Carrera); RDS.Name = "DataSet1";//This refers to the dataset name in the RDLC file RDS.Value = Consulta.IndiceReprobacion20171Carrera(Carrera); } } } } } report.DataSources.Add(RDS); Byte[] mybytes2 = report.Render(Formato); using (FileStream fs = new FileStream(Server.MapPath("~/ArchivosTemporales/" + nombre), FileMode.Append, FileAccess.Write)) { fs.Write(mybytes2, 0, mybytes2.Length); } try { Response.AppendHeader("content-disposition", "attachment; filename=" + nombre); Response.TransmitFile("~/ArchivosTemporales/" + nombre); Response.Flush(); } finally { File.Delete(Server.MapPath("~/ArchivosTemporales/" + nombre)); } }