Esempio n. 1
1
  private byte[] generaXls(List lista) throws JRException {
    Map<String, Object> params = new HashMap<>();
    JRXlsExporter exporter = new JRXlsExporter();
    ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
    JasperDesign jd =
        JRXmlLoader.load(
            this.getClass()
                .getResourceAsStream("/mx/edu/um/mateo/inventario/reportes/almacenes.jrxml"));
    JasperReport jasperReport = JasperCompileManager.compileReport(jd);
    JasperPrint jasperPrint =
        JasperFillManager.fillReport(jasperReport, params, new JRBeanCollectionDataSource(lista));
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, byteArrayOutputStream);
    exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
    exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
    exporter.setParameter(
        JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);
    exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, Boolean.TRUE);
    exporter.setParameter(JRXlsExporterParameter.IGNORE_PAGE_MARGINS, Boolean.TRUE);
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
    exporter.exportReport();
    byte[] archivo = byteArrayOutputStream.toByteArray();

    return archivo;
  }
Esempio n. 2
0
  private static JRExporter getJREXporter(final String extension) {
    if ("pdf".equalsIgnoreCase(extension)) {
      JRPdfExporter exporter = new JRPdfExporter();
      //			exporter.setParameter(JRPdfExporterParameter.PDF_JAVASCRIPT, "this.print();");

      return exporter;

    } else if ("html".equalsIgnoreCase(extension)) {
      return new JRHtmlExporter();

    } else if ("xls".equalsIgnoreCase(extension)) {
      JRXlsExporter exporterXLS = new JRXlsExporter();
      exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
      exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
      exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
      exporterXLS.setParameter(
          JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

      return exporterXLS;

    } else if ("txt".equalsIgnoreCase(extension)) {
      return new JRTextExporter();
    } else if ("csv".equalsIgnoreCase(extension)) {
      return new JRCsvExporter();
    } else if ("docx".equalsIgnoreCase(extension)) {
      return new JRDocxExporter();
    }
    return null;
  }
Esempio n. 3
0
  protected void generateXLSOutput(
      String reportName,
      JasperPrint jasperPrint,
      HttpServletResponse resp,
      HashMap<String, Object> params)
      throws IOException, JRException {
    String reportfilename = (reportName) + ".xls";
    JRXlsExporter exporterXLS = new JRXlsExporter();
    exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
    // exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.TRUE);
    exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
    exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
    exporterXLS.setParameter(
        JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.FALSE);
    exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, resp.getOutputStream());
    for (Iterator<?> iterator = params.keySet().iterator(); iterator.hasNext(); ) {
      String key = (String) iterator.next();
      try {
        PdfReportParam.class.getDeclaredField(key);
        Field field = JRXlsExporterParameter.class.getDeclaredField(key);
        field.setAccessible(true);
        exporterXLS.setParameter(
            (JRExporterParameter) field.get(JRPdfExporterParameter.class), params.get(key));
      } catch (Exception e) {
        // Xls Param will only valid in report param
      }
    }
    resp.setHeader("Content-Disposition", "inline;filename=" + reportfilename);
    resp.setContentType("application/vnd.ms-excel");

    exporterXLS.exportReport();
    resp.getOutputStream().close();
    // clear();
  }
  public static void exportToExcel(String jrprintFileName, String excelFileName) throws Exception {
    long start = System.currentTimeMillis();
    File sourceFile = new File(URL + jrprintFileName);
    JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);
    File destFile = new File(URL + excelFileName);

    JRXlsExporter exporter = new JRXlsExporter();

    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);

    exporter.exportReport();

    System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
    System.out.println("成功创建了一个Excel文档");
  }
Esempio n. 5
0
 /** 导出excel */
 public static void exportExcel(
     JasperPrint jasperPrint,
     String defaultFilename,
     HttpServletRequest request,
     HttpServletResponse response)
     throws IOException, JRException {
   logger.debug("执行导出excel   The method======= exportExcel() start.......................");
   /*
    * 设置头信息
    */
   response.setContentType("application/vnd.ms-excel");
   String defaultname = null;
   if (defaultFilename.trim() != null && defaultFilename != null) {
     defaultname = defaultFilename + ".xls";
   } else {
     defaultname = "export.xls";
   }
   String fileName = new String(defaultname.getBytes("gbk"), "utf-8");
   response.setHeader("Content-disposition", "attachment; filename=" + fileName);
   ServletOutputStream ouputStream = response.getOutputStream();
   JRXlsExporter exporter = new JRXlsExporter();
   exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
   exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);
   exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
   exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
   exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
   exporter.exportReport();
   ouputStream.flush();
   ouputStream.close();
 }
  public void xls() throws JRException {
    long start = System.currentTimeMillis();
    File sourceFile = new File("build/reports/DataSourceReport.jrprint");

    JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);

    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");

    JRXlsExporter exporter = new JRXlsExporter();

    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);

    exporter.exportReport();

    System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
  }
 private void cargarPropiedadesReporte(JRXlsExporter exporter) {
   SimpleXlsReportConfiguration configuracionExcel = new SimpleXlsReportConfiguration();
   configuracionExcel.setDetectCellType(Boolean.TRUE);
   configuracionExcel.setOnePagePerSheet(Boolean.FALSE);
   configuracionExcel.setWhitePageBackground(Boolean.FALSE);
   configuracionExcel.setRemoveEmptySpaceBetweenColumns(Boolean.TRUE);
   configuracionExcel.setRemoveEmptySpaceBetweenRows(Boolean.TRUE);
   configuracionExcel.setIgnoreCellBorder(Boolean.FALSE);
   exporter.setConfiguration(configuracionExcel);
 }
Esempio n. 8
0
  public static void generateXLSReport(JasperPrint jp, String path) throws Exception {
    // JasperExportManager.exp   exportReportToPdfFile(jp, path);

    if (jp != null) {

      JRXlsExporter exporter = new JRXlsExporter();
      exporter.setParameter(JRXlsExporterParameter.JASPER_PRINT, jp);

      OutputStream output = new FileOutputStream(new File(path));
      exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, output);

      System.out.print(exporter.getParameters().toString());
      exporter.exportReport();

      output.close();

    } else {
      System.out.print("problme XLS");
    }
  }
  public void xls() throws JRException {
    long start = System.currentTimeMillis();
    File sourceFile = new File("build/reports/JRMDbReport.jrprint");

    JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);

    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");

    JRXlsExporter exporter = new JRXlsExporter();

    exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
    exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile));
    SimpleXlsReportConfiguration configuration = new SimpleXlsReportConfiguration();
    configuration.setOnePagePerSheet(false);
    exporter.setConfiguration(configuration);

    exporter.exportReport();

    System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
  }
  public void generarReporteEvaluador() {
    HttpServletRequest request =
        (HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext().getRequest();

    ByteArrayOutputStream outReporte = new ByteArrayOutputStream();
    String pathJasperReporte =
        request.getSession().getServletContext().getRealPath("")
            + "/reportesJasper/variables/cuantitativasPorInformacionIes.jasper";

    Map<String, Object> parametrosReporte = new HashMap<>();

    String pathLogo =
        request.getSession().getServletContext().getRealPath("") + "/images/logo_ceaaces.png";
    parametrosReporte.put("par_logo", pathLogo);
    parametrosReporte.put("ies", informacionIesDTO.getIes().getNombre());

    // parametrosReporte.put("SUBREPORT_DIR", request.getSession()
    // .getServletContext().getRealPath("")
    // + "/reportesJasper/mallasGrafico/");
    try {

      JRDataSource dataSourceMallas =
          new JRBeanCollectionDataSource(listaValoresVariablesEvaluador);
      if (dataSourceMallas != null) {
        JRXlsExporter exporter = new JRXlsExporter();
        cargarPropiedadesReporte(exporter);

        JasperPrint jasperPrint =
            JasperFillManager.fillReport(pathJasperReporte, parametrosReporte, dataSourceMallas);
        exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
        exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(outReporte));

        exporter.exportReport();
        reporteBytes = outReporte.toByteArray();
      }
    } catch (Exception e) {
      e.printStackTrace();
      JsfUtil.msgError("Error al generar el reporte, comuníquese con el administrador del sistema");
    }
  }
  public void xls() throws JRException {
    long start = System.currentTimeMillis();
    File sourceFile = new File(TMP_DIR + ALL_CHARTS_REPORT_JRPRINT);
    Map<String, String> dateFormats = new HashMap<String, String>();
    dateFormats.put("EEE, MMM d, yyyy", "ddd, mmm d, yyyy");
    JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);
    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");

    JRXlsExporter exporter = new JRXlsExporter();

    exporter.setExporterInput(new SimpleExporterInput(jasperPrint));
    exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(destFile));
    SimpleXlsReportConfiguration configuration = new SimpleXlsReportConfiguration();
    configuration.setOnePagePerSheet(true);
    configuration.setDetectCellType(true);
    configuration.setFormatPatternsMap(dateFormats);
    exporter.setConfiguration(configuration);

    exporter.exportReport();

    System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
  }
  public void serveResource(ResourceRequest resourceRequest, ResourceResponse resourceResponse) {

    try {

      String portletId = ParamUtil.getString(resourceRequest, "portletId");
      LOGGER.debug("portlet id--" + portletId);
      SimpleDateFormat timeStampFormat = new SimpleDateFormat(TIMESTAMP_FORMAT_FOR_EXCEL);
      PortletSession session = resourceRequest.getPortletSession();
      String timeStamp = timeStampFormat.format(Calendar.getInstance().getTime());
      String fileName = "Location_Tracker" + timeStamp + ".xls";
      List<LocationDetailsVO> locationDetailList =
          LocationTrackerReportsUtil.getLocationDetailsVoList(resourceRequest);
      JRBeanCollectionDataSource reportList = new JRBeanCollectionDataSource(locationDetailList);
      JasperReport report =
          JasperCompileManager.compileReport(
              session.getPortletContext().getRealPath("/reports/location_tracker_report.jrxml"));
      JasperPrint print =
          JasperFillManager.fillReport(report, new HashMap<String, Object>(), reportList);

      OutputStream os = resourceResponse.getPortletOutputStream();
      JRXlsExporter exporterXLS = new JRXlsExporter();
      exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, print);
      exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, os);
      exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
      exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
      exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
      exporterXLS.setParameter(
          JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
      exporterXLS.exportReport();

      resourceResponse.setContentType("application/x-excel");
      resourceResponse.setProperty("Content-Disposition", "attachment; filename=" + fileName);

    } catch (JRException jre) {
      LOGGER.error("Error in exporting the resluts:" + jre.getMessage(), jre);
    } catch (Exception e) {
      LOGGER.error("Error in exporting the resluts:" + e.getMessage(), e);
    }
  }
Esempio n. 13
0
  public static void exportReportXls(JasperPrint jp, String path)
      throws JRException, FileNotFoundException {
    JRXlsExporter exporter = new JRXlsExporter();

    File outputFile = new File(path);
    File parentFile = outputFile.getParentFile();
    if (parentFile != null) {
      parentFile.mkdirs();
    }
    FileOutputStream fos = new FileOutputStream(outputFile);

    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jp);
    exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, fos);
    exporter.setParameter(JRXlsAbstractExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
    exporter.setParameter(JRXlsAbstractExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
    exporter.setParameter(JRXlsAbstractExporterParameter.IS_IGNORE_GRAPHICS, Boolean.FALSE);

    exporter.exportReport();

    logger.debug("XLS Report exported: " + path);
  }
  public void xls() throws JRException {
    long start = System.currentTimeMillis();
    File sourceFile = new File("build/reports/FirstJasper.jrprint");

    JasperPrint jasperPrint = (JasperPrint) JRLoader.loadObject(sourceFile);

    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");

    Map dateFormats = new HashMap();
    dateFormats.put("EEE, MMM d, yyyy", "ddd, mmm d, yyyy");

    JRXlsExporter exporter = new JRXlsExporter();

    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
    exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
    exporter.setParameter(JRXlsExporterParameter.FORMAT_PATTERNS_MAP, dateFormats);

    exporter.exportReport();

    System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
  }
  /** @see HttpServlet#doGet(HttpServletRequest request, HttpServletResponse response) */
  protected void doGet(HttpServletRequest request, HttpServletResponse response)
      throws ServletException, IOException {
    // TODO Auto-generated method stub

    try {
      System.out.println("Genetate Report");
      // Get requested student id from user request
      //	String studentId = request.getParameter("sid");

      // Get requested report type from user request
      String reportType = request.getParameter("reportType");

      // Setting Default report Type
      if (reportType == null || reportType.trim().length() == 0) {
        reportType = "pdf";
      }

      // Get servlet Out put stream to displat report at client side
      ServletOutputStream sos = response.getOutputStream();

      // Construct path for your .jrxml file
      ServletContext application = getServletContext();
      String prefix = application.getRealPath("\\");
      // String file = getInitParameter("reportTemplet");
      String file = "AveTechEventReport.jrxml";
      String path = prefix + file;

      System.out.println("Path : " + path);

      // Load that .jrxml file in Jasper Design
      JasperDesign jasperDesign = JRXmlLoader.load(path);

      // Compile that .jrxml file into .jasper file
      JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);

      /* Populate data from your database It must contain all the fields used in designing a .jrxml file
         Here we have used Java Bean Data Source in generating report.
         So populate ArrayList which contains your collection of your beans.
      */

      JRBeanCollectionDataSource ds =
          new JRBeanCollectionDataSource(AdminDAO.getAllEventData(), false);

      // Filling the reports using your .jasper file and generated Java Bean Datasource
      JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, null, ds);

      // Response for generating PDF report
      if (reportType != null && reportType.equals("pdf")) {
        System.out.println("PDF");
        response.setContentType("application/pdf");
        JRPdfExporter expoterPDF = new JRPdfExporter();
        expoterPDF.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
        expoterPDF.setParameter(JRExporterParameter.OUTPUT_STREAM, sos);
        expoterPDF.exportReport();
      }

      // Response for generating EXCEL report
      if (reportType != null && reportType.equals("excel")) {
        response.setContentType("application/vnd.ms-excel");
        JRXlsExporter exporterXLS = new JRXlsExporter();
        exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
        exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, sos);
        exporterXLS.exportReport();
      }

      // Response for generating WORD report
      if (reportType != null && reportType.equals("word")) {
        response.setContentType("application/msword");
        JRRtfExporter exporterRTF = new JRRtfExporter();
        exporterRTF.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
        exporterRTF.setParameter(JRExporterParameter.OUTPUT_STREAM, sos);
        exporterRTF.exportReport();
      }

      // Closing all opened streams
      sos.flush();
      sos.close();
    } catch (Exception ex) {
      ex.printStackTrace();
    }
  }
  public void generarReporteInformeEvaluacion() {
    HttpServletRequest request =
        (HttpServletRequest) FacesContext.getCurrentInstance().getExternalContext().getRequest();

    ListaIesController controller =
        (ListaIesController) JsfUtil.obtenerObjetoSesion("listaIesController");

    IesDTO ies = controller.getIes();

    ByteArrayOutputStream outReporte = new ByteArrayOutputStream();
    String pathJasperReporteCuantitativas =
        request.getSession().getServletContext().getRealPath("")
            + "/reportesJasper/variables/informeEvaluacionCuantitativas.jasper";

    String pathJasperReporteCualitativas =
        request.getSession().getServletContext().getRealPath("")
            + "/reportesJasper/variables/informeEvaluacionCualitativas.jasper";

    Map<String, Object> parametrosReporte = new HashMap<>();

    String pathLogo =
        request.getSession().getServletContext().getRealPath("") + "/images/logo_ceaaces.png";
    parametrosReporte.put("par_logo", pathLogo);
    parametrosReporte.put("IES", ies.getNombre());
    parametrosReporte.put("CODIGO_IES", ies.getCodigo());
    parametrosReporte.put("ID_INFORMACION_IES", informacionIesDTO.getId());
    parametrosReporte.put("ID_PROCESO", controller.getFaseIesDTO().getProcesoDTO().getId());

    DataSource dataSource = null;
    Connection connection = null;
    try {
      InitialContext ic = new InitialContext();
      Context xmlContext = (Context) ic.lookup("java:comp/env");
      dataSource = (DataSource) xmlContext.lookup("jdbc/casDbConnection");
      connection = dataSource.getConnection();

      JRXlsExporter exporter = new JRXlsExporter();
      cargarPropiedadesReporte(exporter);

      JasperPrint jasperCuantitativas =
          JasperFillManager.fillReport(
              pathJasperReporteCuantitativas, parametrosReporte, connection);
      JasperPrint jasperPrintCualitativas =
          JasperFillManager.fillReport(
              pathJasperReporteCualitativas, parametrosReporte, connection);
      ArrayList<JasperPrint> hojasReporte = new ArrayList<JasperPrint>();
      hojasReporte.add(jasperCuantitativas);
      hojasReporte.add(jasperPrintCualitativas);

      exporter.setExporterInput(SimpleExporterInput.getInstance(hojasReporte));
      exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(outReporte));

      exporter.exportReport();
      reporteBytes = outReporte.toByteArray();
      outReporte.flush();
      outReporte.close();
    } catch (Exception e) {
      e.printStackTrace();
      JsfUtil.msgError(
          "Error al generar el reporte, comuníquese con el administrador del sistema");
    } finally {
      try {
        if (connection != null) {
          connection.close();
        }
      } catch (Exception ex) {
        ex.printStackTrace();
      }
    }
  }
  public static File generate(HrReport report, String outputFormat, String jrxmlUrl)
      throws IOException {

    String url = Context.getRuntimeProperties().getProperty("connection.url", null);
    Connection conn;
    try {
      conn = connect(url);
    } catch (SQLException e) {
      log.error("Error connecting to DB.", e);
      return null;
    }
    Map<String, Object> map = new HashMap<String, Object>();
    for (HrReportParameter reportParameter : report.getParameters()) {
      if (reportParameter != null)
        if (reportParameter.getName() != null)
          map.put(reportParameter.getName(), reportParameter.getValue());
    }
    log.debug("Report parameter map: " + map);
    String exportPath = OpenmrsUtil.getApplicationDataDirectory();
    URL resourceUrl = new URL(jrxmlUrl);
    InputStream is = resourceUrl.openStream();
    BufferedReader br = new BufferedReader(new InputStreamReader(is));
    FileWriter appDirJrxml = new FileWriter(new File(exportPath + report.getFileName()));
    BufferedWriter bw = new BufferedWriter(appDirJrxml);
    String line;
    while ((line = br.readLine()) != null) {
      bw.write(line);
      bw.write("\n");
    }
    bw.flush();
    bw.close();
    JasperPrint jasperPrint = null;
    try {
      JasperDesign jasperDesign = JRXmlLoader.load(exportPath + report.getFileName());
      JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign);
      jasperPrint = JasperFillManager.fillReport(jasperReport, map, conn);
      if (outputFormat.equals("PDF")) {
        File pdfFile =
            new File(
                exportPath
                    + report.getName()
                    + new SimpleDateFormat("dd-MM-yyyy-HH-mm-ss").format(new Date())
                    + ".pdf");
        JasperExportManager.exportReportToPdfFile(jasperPrint, pdfFile.getAbsolutePath());
        return pdfFile;
      } else if (outputFormat.equals("Excel")) {
        ByteArrayOutputStream output = new ByteArrayOutputStream();
        File outputfile =
            new File(
                exportPath
                    + report.getName()
                    + new SimpleDateFormat("dd-MM-yyyy-HH-mm-ss").format(new Date())
                    + ".xls");
        OutputStream outputfileStream = new FileOutputStream(outputfile);
        JRXlsExporter exporterXLS = new JRXlsExporter();
        exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
        exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, output);
        exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
        exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
        exporterXLS.setParameter(
            JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
        exporterXLS.exportReport();
        outputfileStream.write(output.toByteArray());
        outputfileStream.flush();
        outputfileStream.close();
        return outputfile;
      }
    } catch (JRException e) {
      log.error("Error generating report", e);
    } finally {
      try {
        if (!conn.isClosed()) {
          conn.close();
        }
      } catch (SQLException e) {
        log.error("Exception closing report connection.", e);
      }
    }
    return null;
  }