public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { crConsolidatedReports rpt = new crConsolidatedReports(); rpt.Site = this.Site; return(rpt); }
private void frmConsolidatedReports_Load(object sender, EventArgs e) { using (new LoadingClass.PleaseWait(this.Location, "Generando...")) { rp = new Reports.crConsolidatedReports(); foreach (var com in _componentId) { ChooseReport(rp, com); } crystalReportViewer1.EnableDrillDown = false; crystalReportViewer1.ReportSource = rp; ReportDocument repDoc = rp; repDoc.ExportOptions.ExportFormatType = ExportFormatType.PortableDocFormat; repDoc.ExportOptions.ExportDestinationType = ExportDestinationType.DiskFile; DiskFileDestinationOptions objDiskOpt = new DiskFileDestinationOptions(); objDiskOpt.DiskFileName = Application.StartupPath + @"\TempMerge\Crystal1.pdf"; repDoc.ExportOptions.DestinationOptions = objDiskOpt; repDoc.Export(); // //crystalReportViewer1.Show(); } }
private void frmConsolidatedReports_Load(object sender, EventArgs e) { using (new LoadingClass.PleaseWait(this.Location, "Generando...")) { rp = new Reports.crConsolidatedReports(); foreach (var com in _componentId) { ChooseReport(rp, com); } crystalReportViewer1.EnableDrillDown = false; crystalReportViewer1.ReportSource = rp; crystalReportViewer1.Show(); } }
private void ChooseReport(crConsolidatedReports rp, string componentId) { DataSet ds = null; switch (componentId) { case Constants.INFORME_CERTIFICADO_APTITUD: ds = GetReportCertificadoAptitud(); var s = ds.Tables[0].Rows[0]["i_EsoTypeId"].ToString(); if (s == "3") { rp.Subreports["crOccupationalMedicalAptitudeCertificateRetiros.rpt"].SetDataSource(ds); rp.DetailSection9.SectionFormat.EnableSuppress = false; } else { rp.Subreports["crOccupationalMedicalAptitudeCertificate.rpt"].SetDataSource(ds); rp.SectionCertificadoAptitud.SectionFormat.EnableSuppress = false; } break; case Constants.OSTEO_MUSCULAR_ID_1: // Osteomuscular2 ds = GetReportOsteomuscular2(); rp.Subreports["crMuscoloEsqueletico.rpt"].SetDataSource(ds); rp.SectionOsteomuscular1.SectionFormat.EnableSuppress = false; // Osteomuscular3 ds = GetReportOsteo(); rp.Subreports["crOsteo.rpt"].SetDataSource(ds); rp.SectionOsteomuscular2.SectionFormat.EnableSuppress = false; break; case Constants.OSTEO_MUSCULAR_ID_2: // Osteomuscular1 ds = GetReportOsteomuscular1(); rp.Subreports["crEvaluacionOsteomuscular.rpt"].SetDataSource(ds); rp.SectionOsteomuscular1.SectionFormat.EnableSuppress = false; break; case Constants.INFORME_HISTORIA_OCUPACIONAL: ds = GetReportHistoriaOcupacional(); rp.Subreports["crHistoriaOcupacional.rpt"].SetDataSource(ds); rp.SectionHistoriaOcupacional.SectionFormat.EnableSuppress = false; rp.SectionHistoriaOcupacional.SectionFormat.PageOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape; rp.SectionHistoriaOcupacional.ReportObjects["SubReportHistoriaOcupacional"].Width = 15905; break; case Constants.ALTURA_7D_ID: ds = GetReportAnexo7D(); rp.Subreports["crAnexo7D.rpt"].SetDataSource(ds); rp.SectionAnexo7D.SectionFormat.EnableSuppress = false; break; case Constants.ALTURA_ESTRUCTURAL_ID: ds = GetReportAlturaFisica(); rp.Subreports["crAlturaMayor.rpt"].SetDataSource(ds); rp.SectionAlturaEstructural.SectionFormat.EnableSuppress = false; break; case Constants.INFORME_LABORATORIO_ID: // Falta implementar //rp.SectionLaboratorio.SectionFormat.EnableSuppress = false; break; case Constants.ELECTROCARDIOGRAMA_ID: ds = GetReportElectrocardiograma(); rp.Subreports["crEstudioElectrocardiografico.rpt"].SetDataSource(ds); rp.SectionElectrocardiograma.SectionFormat.EnableSuppress = false; break; case Constants.PRUEBA_ESFUERZO_ID: ds = GetReportPruebaEsfuerzo(); rp.Subreports["crPruebaEsfuerzo.rpt"].SetDataSource(ds); rp.SectionPruebaEsfuerzo.SectionFormat.EnableSuppress = false; break; case Constants.ODONTOGRAMA_ID: ds = GetReportOdontologia(); rp.Subreports["crOdontograma.rpt"].SetDataSource(ds); rp.SectionOdontologia.SectionFormat.EnableSuppress = false; break; case Constants.AUDIOMETRIA_ID: // Falta implementar ds = GetReportAudiometria(); rp.Subreports["crFichaAudiometria.rpt"].SetDataSource(ds); rp.SectionAudiometria.SectionFormat.EnableSuppress = false; // Historia Ocupacional Audiometria ds = GetReportHistoriaOcupacionalAudiometria(); rp.Subreports["crHistoriaOcupacionalAudiometria.rpt"].SetDataSource(ds); rp.SectionHistoriaOcupacionalAudiometria.SectionFormat.EnableSuppress = false; rp.SectionHistoriaOcupacionalAudiometria.SectionFormat.PageOrientation = CrystalDecisions.Shared.PaperOrientation.Landscape; rp.SectionHistoriaOcupacionalAudiometria.ReportObjects["SubReportHistoriaOcupacionalAudiometria"].Width = 15905; break; case Constants.GINECOLOGIA_ID: // Falta implementar ds = GetReportGinecologia(); rp.Subreports["crEvaluacionGenecologica.rpt"].SetDataSource(ds); rp.SectionGinecologia.SectionFormat.EnableSuppress = false; break; case Constants.OFTALMOLOGIA_ID: ds = GetReportOftalmologia(); rp.Subreports["crOftalmologia.rpt"].SetDataSource(ds); rp.SectionOftalmologia.SectionFormat.EnableSuppress = false; break; case Constants.PSICOLOGIA_ID: ds = GetReportPsicologia(); rp.Subreports["InformePsicologicoOcupacional.rpt"].SetDataSource(ds); rp.SectionPsicologia.SectionFormat.EnableSuppress = false; break; case Constants.RX_TORAX_ID: ds = GetReportRX(); rp.Subreports["crInformeRadiologico.rpt"].SetDataSource(ds); rp.SectionRayosX.SectionFormat.EnableSuppress = false; break; case Constants.OIT_ID: ds = GetReportInformeRadiograficoOIT(); rp.Subreports["crInformeRadiograficoOIT.rpt"].SetDataSource(ds); rp.SectionRayosXOIT.SectionFormat.EnableSuppress = false; break; case Constants.TAMIZAJE_DERMATOLOGIO_ID: ds = GetReportTamizajeDermatologico(); rp.Subreports["crTamizajeDermatologico.rpt"].SetDataSource(ds); rp.SectionTamizajeDermatologico.SectionFormat.EnableSuppress = false; break; case Constants.ESPIROMETRIA_ID: ds = GetReportEspirometriaCuestionario(); rp.Subreports["crCuestionarioEspirometria.rpt"].SetDataSource(ds); rp.SectionEspirometriaCuestionario.SectionFormat.EnableSuppress = false; break; //case Constants.ESPIROMETRIA_ID: // ds = GetReportEspirometria(); // rp.Subreports["crInformeEspirometria.rpt"].SetDataSource(ds); // rp.SectionEspirometria.SectionFormat.EnableSuppress = false; // break; case Constants.EVALUACION_PSICOLABORAL: ds = GetReportEvaluacionPsicolaboralPersonal(); rp.Subreports["crEvaluacionPsicolaboralPersonal.rpt"].SetDataSource(ds); rp.SectionEvaluacionPsicolaboralPersonal.SectionFormat.EnableSuppress = false; break; case Constants.TESTOJOSECO_ID: ds = GetTestOjoSeco(); rp.Subreports["crCuestionarioOjoSeco.rpt"].SetDataSource(ds); rp.DetailSection1.SectionFormat.EnableSuppress = false; break; case Constants.TOXICOLOGICO_COCAINA_MARIHUANA_ID: ds = GetAutorizacionDrogas(); rp.Subreports["crAutorizacionDosajeDrogras.rpt"].SetDataSource(ds); rp.DetailSection2.SectionFormat.EnableSuppress = false; break; case Constants.AGLUTINACIONES_LAMINA_ID: ds = GetAntigenosFebriles(); rp.Subreports["crAntigenosFebriles.rpt"].SetDataSource(ds); rp.DetailSection3.SectionFormat.EnableSuppress = false; break; /////////////////////////////////////// case Constants.EXAMEN_COMPLETO_DE_ORINA_ID: ds = GetExamenCompletoOrina(); rp.Subreports["crExamenCompletoOrina.rpt"].SetDataSource(ds); rp.DetailSection4.SectionFormat.EnableSuppress = false; break; case Constants.HEMOGRAMA_COMPLETO_ID: ds = GetHemogramaCompleto(); rp.Subreports["crHemogramaCompleto.rpt"].SetDataSource(ds); rp.DetailSection5.SectionFormat.EnableSuppress = false; break; case Constants.PARASITOLOGICO_SIMPLE_ID: ds = GetParasitologicoSimple(); rp.Subreports["crParasitologicoSimple.rpt"].SetDataSource(ds); rp.DetailSection6.SectionFormat.EnableSuppress = false; break; case Constants.PARASITOLOGICO_SERIADO_ID: ds = GetParasitologicoSeriado(); rp.Subreports["crParasitologicoSeriado.rpt"].SetDataSource(ds); rp.DetailSection7.SectionFormat.EnableSuppress = false; break; case Constants.C_N_ID: ds = GetCuestionarioNordico(); rp.Subreports["crCuestionarioNordico.rpt"].SetDataSource(ds); rp.DetailSection8.SectionFormat.EnableSuppress = false; break; case Constants.CUESTIONARIO_ACTIVIDAD_FISICA: ds = GetCuestionarioActividadFisica(); rp.Subreports["crCuestionarioActividadFisica.rpt"].SetDataSource(ds); rp.DetailSection10.SectionFormat.EnableSuppress = false; break; case Constants.INFORME_ECOGRAFICO_PROSTATA_ID: ds = GetInformeEcograficoProstata(); rp.Subreports["crInformeEcograficoProstata.rpt"].SetDataSource(ds); rp.DetailSection11.SectionFormat.EnableSuppress = false; break; case Constants.ECOGRAFIA_ABDOMINAL_ID: ds = GetInformeEcograficoAbdominal(); rp.Subreports["crInformeEcograficoAbdominal.rpt"].SetDataSource(ds); rp.DetailSection12.SectionFormat.EnableSuppress = false; break; case Constants.ECOGRAFIA_RENAL_ID: ds = GetInformeEcograficoRenal(); rp.Subreports["crInformeEcograficoRenal.rpt"].SetDataSource(ds); rp.DetailSection13.SectionFormat.EnableSuppress = false; break; case Constants.TEST_VERTIGO_ID: ds = GetTestVertigo(); rp.Subreports["crTestDeVertigo.rpt"].SetDataSource(ds); rp.DetailSection15.SectionFormat.EnableSuppress = false; break; case Constants.EVA_CARDIOLOGICA_ID: ds = GetEvaCardiologica(); rp.Subreports["crEvaluacionCardiologicaSM.rpt"].SetDataSource(ds); rp.DetailSection14.SectionFormat.EnableSuppress = false; break; case Constants.EVA_OSTEO_ID: ds = GetEvaOsteoSanMartin(); rp.Subreports["crOsteoSanMartin.rpt"].SetDataSource(ds); rp.DetailSection16.SectionFormat.EnableSuppress = false; break; case Constants.HISTORIA_CLINICA_PSICOLOGICA_ID: ds = GetHistoriaClinicaPsicologica(); rp.Subreports["crHistoriaClinicaPsicologica.rpt"].SetDataSource(ds); rp.DetailSection17.SectionFormat.EnableSuppress = false; break; case Constants.EVA_NEUROLOGICA_ID: ds = GetEvaNeurologica(); rp.Subreports["crEvaluacionNeurologica.rpt"].SetDataSource(ds); rp.DetailSection18.SectionFormat.EnableSuppress = false; break; default: break; } }